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.
milcah answered 2 months agoRelated 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
Latest Questions
- TASK back to top In the contemporary management environment, mergers and acquisitions are hot topics; particularly...
- A room with 2.7-m-high ceilings has a metal plate on the floor with V = 0V...
- which of the following statements are true? a) the same nuclear changes (creation/destruction of specific nucleons)...
- Overview: Advances in technology have impacted many facets of the auditing process, from assessing risk and...
- Background: This course is all about data visualization. However, we must first have some understanding about...
- A rescue helicopter lifts a 70.6-kg person straight up by means of a cable. The person...
- Dolomite, [CaMg(CO3)2] is found in a soil sample. A geochemist titrates 24.65 g of soil with...
ADVERTISEMENT