Purchase Solution

Develop a multiple linear regression model & compare

Not what you're looking for?

Ask Custom Question

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)

Attachments
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 ...

Solution provided by:
Carol Sargent, PhD
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.

View More Free Quizzes
Related BrainMass Solutions

  • simple linear regression models

    169332 simple linear regression models Develop simple linear regression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually.

  • Statistics Problem Set: Multiple Regression Model

    507462 Statistics Problem Set: Multiple Regression Model 14.2 Develop a multiple regression model of the form y = b0 + b^x1E. Using the following data to predict y from x.

  • Simple and Multiple Regression

    Develop simple linear regression models for predicting sales as a function of the number of each type of ad. Compare these results to a multiple linear regression model using both independent variables.

  • Linear Regression using intrinsic job satisfaction

    46865 Linear Regression Linear Regression Help.. Using the attached excel spreadsheet (database) Develop a Linear Regression model using intrinsic job satisfaction and extrinsic job satisfaction.

  • Regression Analysis - Using PHStat or Excel

    613800 Regression Analysis - Using PHStat or Excel [1] A research analyst for an oil company wants to develop a model to predict miles per gallon based on highway speed.

  • Managerial Reports: Alumni

    Any possible modification you suggest for a better-fit multiple linear regression model? Adding or dropping independent variables? Change to any nonlinear model? Explain your suggestion. Use the information provided in the attached Excel file.

  • Multiple Regression explaination

    For example how do I determine if simple, linear regression is suitable or if I need to try a different, non-linear form? Please see the attached file. Multiple Regression explanation

  • Multiple regression model testing

    41998 Multiple regression model testing I need to use my attached database to develop a multiple regression model with the dependent variable being the overall job satisfaction.

  • Solve forecasting questions using naive, moving average

    Design a scenario that requires to conduct a multiple regression analysis. You need to find data, construct the linear model, run analysis, evaluate your model, and interpret the results.

View More Related Solutions