Question

In: Math

How do horsepower and weight affect the mileage of family cars? Data from a sample of...

How do horsepower and weight affect the mileage of family cars? Data from a sample of 12 2012 family cars are given below (Data extracted from “Top 2012 Cars,” Consumer Reports, April 2012, pp. 40–73.) Develop a regression model to predict mileage (as measured by miles per gallon) based on the horsepower of the car’s engine and the weight of the car (in pounds). Car MPG Horsepower Weight Audi A3 25 200 3305 Chrysler 200 21 173 3590 Dodge Avenger 21 173 3440 Ford Fusion 24 240 3365 Honda Accord 25 177 3285 Kia Optima 25 200 3260 Mazda6 24 170 3185 Mitsubishi Galant 23 160 3430 Nissan Altima 26 175 3155 Suburu Legacy 25 170 3390 Toyota Camry 27 173 3155 Volkswagen Passat 25 170 3270 Use Excel to find the multiple regression results for this problem. Include Excel results with your submission. a. State the multiple regression equation for this problem. b. Interpret the meaning of the slopes, b1 and b2, in this problem. c. Does the regression coefficient, b0, has a practical meaning in the context of this problem. d. Predict the miles per gallon for cars that have 190 horsepower and weigh 3,500 pounds. e. Compute the coefficient of multiple determination, r2, and interpret its meaning. f. Compute the adjusted r2.

Solutions

Expert Solution

sol:- From the given data,

The calculations were done by EXCEL shown below.


Related Solutions

The data below was collected from manufacturer advertisements of their vehicles horsepower and highway gas mileage...
The data below was collected from manufacturer advertisements of their vehicles horsepower and highway gas mileage (mpg.). Use this data to answer the following questions. x 158 250 340 350 390 190 220 y 33 28 15 17 11 35 42 1. Find the the correlation coefficient. Round your final answer to four decimal places. r=r=   2. Write the regression equation below. Round all numbers to four decimal places. ˆy=y^= 3. Using the data shown above,predict the the highway gas...
The data below is the mileage (thousands of miles) and age of your cars as sample....
The data below is the mileage (thousands of miles) and age of your cars as sample. Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple...
1. The data below is the city gas mileage for a sample of hybrid cars, as...
1. The data below is the city gas mileage for a sample of hybrid cars, as reported by the Environmental Protection Agency in 2007. 30, 36, 33, 27, 31, 25, 28, 31, 45 mpg Construct and interpret a 95% confidence interval for the population mean for the miles per gallon of hybrids. You may assume that the population of gas mileage normally distributed with no outliers. Answer the following:                         a What is...
The data provided give the gasoline mileage​ (in miles per​ gallon) based on the horsepower of...
The data provided give the gasoline mileage​ (in miles per​ gallon) based on the horsepower of a​ car's engine and the weight of the car​ (in pounds). Using the data​ provided, determine the VIF for each independent variable in the model. Is there reason to suspect the existence of​ collinearity? Determine the VIF for each independent variable in the model. MPG Horsepower Weight 15.8 185 4,758 19.7 106 3,534 20.3 141 3,220 18.8 172 4,466 17.3 166 4,293 27.5 75...
The table shows a short excerpt from the "car weight and mileage" data file on the...
The table shows a short excerpt from the "car weight and mileage" data file on the text CD. That file lists several 2004 model cars with automatic transmission and their x = weight (in pounds) and y = mileage (miles per gallon of gas). The scatterplot is roughly linear and r = -0.74. The regression equation is  = 47.140 - 0.0051x. Automobile Brand Weight Mileage Honda Accord Sedan LX 3137 35 Toyota Corolla 2583 40 Dodge Dakota Club Cab 3869 20...
Where do the artifacts in noise come from? How do they affect the data?
Where do the artifacts in noise come from? How do they affect the data?
The data below is the mileage (thousands of miles) and age of your cars . Year...
The data below is the mileage (thousands of miles) and age of your cars . Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple linear...
The data below is the mileage (thousands of miles) and age of your cars . Year...
The data below is the mileage (thousands of miles) and age of your cars . Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple linear...
Consider a random sample of 15 cars of the same model. Assume that the gas mileage...
Consider a random sample of 15 cars of the same model. Assume that the gas mileage for the population is normally distributed with a standard deviation of 5.2 miles per gallon. Calculate a 90% confidence interval for the mean, given a sample mean of 26.7 miles per gallon.
A sample of 35 cars of a certain kind had an average mileage of 36.2 mpg....
A sample of 35 cars of a certain kind had an average mileage of 36.2 mpg. Assuming that mileage is approximately normally distributed with standard deviation 4 mpg, test the hypothesis that the average mileage for all cars of this type is no less than 34.2 mpg at the 0.01 significance level. Give the value of p you find to two decimal places, and choose the correct conclusion: p=
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT