Question: 4. [25 points] The worksheet Q4 in Assignment 5 Data.xlsx provides the following information for 392 different car models: Cylinders, Displacement, Horsepower, Weight, Acceleration, Miles

the following information for 392 different car models: Cylinders, Displacement, Horsepower, Weight,

4. [25 points] The worksheet Q4 in Assignment 5 Data.xlsx provides the following information for 392 different car models: Cylinders, Displacement, Horsepower, Weight, Acceleration, Miles per gallon (MPG). a. Conduct a multiple regression analysis. Determine an equation that can be used to predict MPG, b. What is the predicted MPG of a car with 4 cylinders, 100 displacement, 80 horsepower, 2450 weight, and 19.5 acceleration? c. Are all independent variables useful for predicting the MPG? Discuss based on the p-value of the independent variables. d. Remove the independent variables that are not useful for predicting the MPG and conduct a multiple regression analysis. What is the equation for predicting MPG? e. What is the predicted MPG for the car described in (b)? Compare the two predictions. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ cyl } & disp & HP & & ght & el & \\ \hline & 8 & 304 & 193 & 4732 & 18.5 & \\ \hline & 8 & 307 & 200 & 4376 & 15 & 10 \\ \hline & 8 & 360 & 215 & 4615 & 14 & 10 \\ \hline & 8 & 400 & 150 & 4997 & 14 & 11 \\ \hline & 8 & 350 & 180 & 3664 & 11 & 11 \\ \hline & 8 & 429 & 208 & 4633 & 11 & 11 \\ \hline & 8 & 318 & 210 & 4382 & 13.5 & 11 \\ \hline & 8 & 350 & 160 & 4456 & 13.5 & 12 \\ \hline 0 & 8 & 400 & 167 & 4906 & 12.5 & 12 \\ \hline 1 & 8 & 383 & 180 & 4955 & 11.5 & 12 \\ \hline 2 & 8 & 350 & 180 & 4499 & 12.5 & 12 \\ \hline 13 & 8 & 429 & 198 & 4952 & 11.5 & 12 \\ \hline 14 & 8 & 455 & 225 & 4951 & 11 & 12 \\ \hline 15 & 8 & 302 & 129 & 3169 & 12 & 13 \\ \hline 16 & 8 & 307 & 130 & 4098 & 14 & 13 \\ \hline 17 & 8 & 302 & 130 & 3870 & 15 & 13 \\ \hline 18 & 8 & 302 & 140 & 4294 & 16 & 13 \\ \hline 19 & 8 & 350 & 145 & 3988 & 13 & 13 \\ \hline 20 & 8 & 350 & 145 & 4055 & 12 & 13 \\ \hline 21 & 8 & 400 & 150 & 4464 & 12 & 13 \\ \hline 22 & 8 & 350 & 150 & 4699 & 14.5 & 13 \\ \hline 23 & 8 & 318 & 150 & 3940 & 13.2 & 13 \\ \hline 24 & 8 & 318 & 150 & 3755 & 14 & 13 \\ \hline 25 & 8 & 350 & 155 & 4502 & 13.5 & 13 \\ \hline 26 & 8 & 351 & 158 & 4363 & 13 & 13 \\ \hline 27. & 8 & 350 & 165 & 4274 & 12 & 13 \\ \hline 28 & 8 & 400 & 170 & 4746 & 12 & 13 \\ \hline 29 & 8 & 360 & 170 & 4654 & 13 & 13 \\ \hline 30 & 8 & 400 & 175 & 5140 & 12 & 13 \\ \hline 31 & 8 & 350 & 175 & 4100 & 13 & 13 \\ \hline 32 & 8 & 360 & 175 & 3821 & 11 & 13 \\ \hline 33. & 8 & 400 & 1902% & 4422 & 12.5 & 13 \\ \hline \end{tabular} 4. [25 points] The worksheet Q4 in Assignment 5 Data.xlsx provides the following information for 392 different car models: Cylinders, Displacement, Horsepower, Weight, Acceleration, Miles per gallon (MPG). a. Conduct a multiple regression analysis. Determine an equation that can be used to predict MPG, b. What is the predicted MPG of a car with 4 cylinders, 100 displacement, 80 horsepower, 2450 weight, and 19.5 acceleration? c. Are all independent variables useful for predicting the MPG? Discuss based on the p-value of the independent variables. d. Remove the independent variables that are not useful for predicting the MPG and conduct a multiple regression analysis. What is the equation for predicting MPG? e. What is the predicted MPG for the car described in (b)? Compare the two predictions. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ cyl } & disp & HP & & ght & el & \\ \hline & 8 & 304 & 193 & 4732 & 18.5 & \\ \hline & 8 & 307 & 200 & 4376 & 15 & 10 \\ \hline & 8 & 360 & 215 & 4615 & 14 & 10 \\ \hline & 8 & 400 & 150 & 4997 & 14 & 11 \\ \hline & 8 & 350 & 180 & 3664 & 11 & 11 \\ \hline & 8 & 429 & 208 & 4633 & 11 & 11 \\ \hline & 8 & 318 & 210 & 4382 & 13.5 & 11 \\ \hline & 8 & 350 & 160 & 4456 & 13.5 & 12 \\ \hline 0 & 8 & 400 & 167 & 4906 & 12.5 & 12 \\ \hline 1 & 8 & 383 & 180 & 4955 & 11.5 & 12 \\ \hline 2 & 8 & 350 & 180 & 4499 & 12.5 & 12 \\ \hline 13 & 8 & 429 & 198 & 4952 & 11.5 & 12 \\ \hline 14 & 8 & 455 & 225 & 4951 & 11 & 12 \\ \hline 15 & 8 & 302 & 129 & 3169 & 12 & 13 \\ \hline 16 & 8 & 307 & 130 & 4098 & 14 & 13 \\ \hline 17 & 8 & 302 & 130 & 3870 & 15 & 13 \\ \hline 18 & 8 & 302 & 140 & 4294 & 16 & 13 \\ \hline 19 & 8 & 350 & 145 & 3988 & 13 & 13 \\ \hline 20 & 8 & 350 & 145 & 4055 & 12 & 13 \\ \hline 21 & 8 & 400 & 150 & 4464 & 12 & 13 \\ \hline 22 & 8 & 350 & 150 & 4699 & 14.5 & 13 \\ \hline 23 & 8 & 318 & 150 & 3940 & 13.2 & 13 \\ \hline 24 & 8 & 318 & 150 & 3755 & 14 & 13 \\ \hline 25 & 8 & 350 & 155 & 4502 & 13.5 & 13 \\ \hline 26 & 8 & 351 & 158 & 4363 & 13 & 13 \\ \hline 27. & 8 & 350 & 165 & 4274 & 12 & 13 \\ \hline 28 & 8 & 400 & 170 & 4746 & 12 & 13 \\ \hline 29 & 8 & 360 & 170 & 4654 & 13 & 13 \\ \hline 30 & 8 & 400 & 175 & 5140 & 12 & 13 \\ \hline 31 & 8 & 350 & 175 & 4100 & 13 & 13 \\ \hline 32 & 8 & 360 & 175 & 3821 & 11 & 13 \\ \hline 33. & 8 & 400 & 1902% & 4422 & 12.5 & 13 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

the file named cardata.xlsx provides the following information for 392 different car models. Cylinders, Displacement, Horsepower, Weight, Acceleration, Miles per gallon (mpg) Determine an equation...

The file Cardata.xlsx provides the following information for 392 different car models: Cylinders Displacement Horsepower Weight Acceleration Miles per gallon (MPG) Determine an equation that can...

I have attached the question. I will post student question when I receive one later. Chapter 2, Customer Behavior and 3, Segmentation of textbook can also be used. Marketing Management: MKT500 Week 1...

View the 2013 Annual Report for the Ford Motor Company, a Fortune 50 company, linked here as well as on the Course Information page. Using this report, answer the following questions: Does the...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

I will really appreciate some help with my economics work. I've been struggling in economics 2370 and would love some help. Thank you so much :) A dataset for a sample of vehicles Download the...

Part 1 Please use "Auto Data." This dataset includes information about 3 9 2 vehicle types. The task is to find a set of variables and their function forms to predict miles per gallon ( i . e . , mpg...

ANOVA & Correlation SPSS Instructions How to Run a One-Way ANOVA in SPSS Your data should have at least 2 variables (your IV and DV). - Your IV should have at least 3 groups - Your DV should be...

Sports Car SUV 1 Wagon Brand Moldel Class 1=Yes = Yes 1= Yes Chevrolet Aveo 4dr 0 0 0 Chevrolet Aveo LS 0 0 0 Chevrolet Cavalier 2dr 0 0 0 Chevrolet Cavalier 4dr 0 0 0 Chevrolet Cavalier LS 0 0 0...

NASA scientists propose using rotating cylindrical craft to replicate gravity while in a weightless environment. Consider such a craft that has a diameter of d - 61 m. a). What is the speed v, in...

The table below shows the size of a firm measured in terms of number of employees and the type of firm are related to. The joint probabilities in the Table 2 were calculated. Number of employees...

Which of the following statements is not required of not - for - profit organizations? A . Statement of financial postion. B . Statement of retained earnings. C . Statement of cash flows. D ....

Assume that you are 30 years old today, and that you are planning on retirement at age 65. Your current salary is $41,000 and you expect your salary to increase at a rate of 3% per year as long as...