Question
You have been hired to conduct business research for the purpose of identifying ways to improve fuel efficiency without disturbing consumer preference.Use the data presented
You have been hired to conduct business research for the purpose of identifying ways to improve fuel efficiency without disturbing consumer preference.Use the data presented to create multiple regression model which explains the impact of the variables you selected on City and Highway fuel economy.
(1) Make a frequency distributions and/or histograms for City MPG and Hwy MPG. Describe the distributions.
(2) Discuss the descriptive statistics for all variables.Use tables to present measures of central tendencies and measures of dispersion for continuous variables.Use tables, graphs, and charts to present frequencies and descriptive for nominal data.Be sure to identify, report, and recommend a treatment for any outliers.
(3) Determine if there is a statistically significant difference in City MPG based on vehicle body style. Be sure to use Tukey's test to determine if all styles are different.Do the same for Hwy MPG.Are the results the same for City and Hwy?
(4) Create scatter plot for X = Weight and Y = City MPG. What does it suggest?Fit a simple regression on the scatter plot. Interpret the slope and fit.
(5) Estimate a multiple regression model using City MPG as the response variable (dependent variable) and several numerical or binary predictors of your choice.Caution: If you use binary predictors, be carefulto omit one of the binary predictors in each group (body style, drive type, transmission type)to avoid perfect multi collinearity.
(6) Did your multiple regression model offer a substantially better fit than the simple regression in step (4)?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started