Quantitative Business Analysis Case Study
[ad_1]
Quantitative Business Analysis Case Study
There are numerous variables that are believed to be predictors of combined (city and highway) fuel efficiency – number of cylinders, engine displacement, transmission type, number of gears, carline class. The information in the Case Study No. 2 Fuel Efficiency Data .xlsx file pertains to a random sample of 2018 vehicle data.
- Develop a multiple linear regression model to predict a vehicle’s combined fuel efficiency-based engine displacement, transmission type, and number of gears as the predictor variables.
- Write the regression equation.
- Discuss the statistical significance of the model using the appropriate regression statistic at a 95% level of confidence.
- Discuss the statistical significance of the coefficient for each independent variable using the appropriate regression statistics at a 95% level of confidence.
- Discuss the statistical significance of the coefficient for each independent variable using the appropriate regression statistics at a 90% level of confidence.
Quantitative Business Analysis Case Study
- Develop a multiple linear regression model to predict a vehicle’s combined fuel efficiency-based number of cylinders, transmission type, and number of gears as the predictor variables.
- Write the regression equation.
- Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence.
- Discuss the statistical significance of the coefficient for each independent variable using the appropriate regression statistics at a 95% level of confidence.
- Interpret the coefficient for each independent variable.
- What percentage of the observed variation in combined highway fuel efficiency is explained by the model?
- Predict the combined fuel efficiency for a vehicle that has 4 cyclinders, 6 gears, automatic transmission and is carline class 6
Compare the regression statistics for the multiple regression models from questions 1 and 2 above. Which model is the preferred model at a 95% level of confidence? Use the Significance F values, p-values for the independent variables, R-squared or Adjusted R-squared values (as appropriate), and standard errors to explain your selection.
Prepare a single Microsoft Excel file to document your regression analyses. Prepare a single Microsoft Word document that outlines your responses for each portion of the case study. Upload BOTH your Excel and Word files for grading via the Canvas submission link. Quantitative Business Analysis Case Study
Need Help with a similar Assignment?
The post Quantitative Business Analysis Case Study appeared first on homeworkcrew.
[ad_2]
Source link
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
