# Develop a multiple linear regression model & compare

Not what you're looking for?

Develop a multiple linear regression model.

A sample of twenty automobiles was taken, and the miles per gallon (MPG), horsepower and total weight were recorded. Develop a linear regression model to predict MPG using horsepower as the only independent variable. Develop another model with weight as the independent variable. Which of these two models is better? Explain.

MPG Horsepower Weight

44 67 1844

44 50 1998

40 62 1752

37 66 1797

34 63 2199

35 90 2404

32 99 2611

30 63 3236

28 91 2606

26 94 2580

26 88 2507

25 124 2922

22 97 2434

20 114 3248

21 102 2812

18 114 3382

18 142 3197

16 153 4380

16 139 4036

(Note: The data provided contains 19 values only)

##### Purchase this Solution

##### Solution Summary

Your tutorial created three regressions, one simple regression using horsepower, one simple regression using weight and a multiple regression with both horsepower and weight to predict miles per gallon (MPG). The solution is in Excel and used the regression function in data analysis.

##### Solution Preview

See Excel file attached. Each regression is a separate tab.

The multiple regression explains more of the variance than either simple regression using ...

###### Education

- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University

###### Recent Feedback

- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

##### Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

##### Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.