Purchase Solution

Multiple regression: City MPG

Not what you're looking for?

Ask Custom Question

Perform a complete multiple regression using City MPG as the response variables. Assess the model using the steps as performed/outlined (correlation matrix, f-test, t-tests, r-sq and standard error). If the full multiple regression needs modification, perform a stepwise regression and select the final model. Briefly note why you selected your final model. Interpret the coefficients of the final model only.

Please see the Excel file for the data.

Attachments
Purchase this Solution

Solution Summary

Multiple regression in City MPG is examined.

Solution Preview

Regression Help
Perform a complete multiple regression using City MPG as the response variables. Assess the model using the steps as performed/outlined in class (correlation matrix, f-test, t-tests, r-sq and standard error). If the full multiple regression needs modification, perform a stepwise regression and select the final model. Briefly note why you selected your final model. Interpret the coefficients of the final model only.
Answer
Correlation Matrix
City Length Width Weight Japan
City 1
Length -0.631204198 1
Width -0.632927505 0.719811378 1
Weight -0.825196386 0.752597232 0.739273687 1
Japan -0.049485851 -0.160046674 -0.266866176 -0.093307413 1
From the correlation matrix it is clear that the highest correlation is between city and Weight.
Step 1
Now we can perform regression analysis with City as the dependent variable and Length, Width, Weight and Japan as the independent variables.
The estimated regression equation is given by,
City = 43.9932 - 0.0039 * Length - 0.1064 * Width - 0.0041 * Weight - 1.3228 * Japan
The model adequacy is measured using the R2 value. Here R2 = 0.7027. Thus 70.27% variability in City can be explained by the regression model.
Standard error of estimate = 2.5055
The overall utility of the suggested model is tested using F test.
Here F statistic is significant with p-value less than 0.05. Hence we can conclude that the suggested model is significant in predicting the dependent variable.
The regression coefficients can be tested using student's t distribution.
The regression coefficient Weight is significant, since the p-value is less than 0.05. But the variables Length, Width and Japan are not significant, since the respective p-values are greater than 0.05. That is, the variables Length, Width ...

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.

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.

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.