1. Math
  2. Statistics And Probability
  3. a us consumer lobby wishes to develop a model to...

Question: a us consumer lobby wishes to develop a model to...

Question details

A US consumer lobby wishes to develop a model to predict gasoline mileage, as measured by miles per gallon, based on the horsepower of the car's engine. The Excel data file AUTO.xls contains these data (also weight) for fifty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, as well as the 99% confidence interval for the slope coefficient and the residual plot. State all numeric answers below correct to 4 decimal places using the Excel output results. Use z and t tables, not cas calculator.

Excel data file AUTO.xls is below.

MPG Horsepower Weight
43.1 48 1985
19.9 110 3365
19.2 105 3535
17.7 165 3445
18.1 139 3205
20.3 103 2830
21.5 115 3245
16.9 155 4360
15.5 142 4054
18.5 150 3940
27.2 71 3190
41.5 76 2144
46.6 65 2110
23.7 100 2420
27.2 84 2490
39.1 58 1755
28.0 88 2605
24.0 92 2865
20.2 139 3570
20.5 95 3155
28.0 90 2678
34.7 63 2215
36.1 66 1800
35.7 80 1915
20.2 85 2965
23.9 90 3420
29.9 65 2380
30.4 67 3250
36.0 74 1980
22.6 110 2800
36.4 67 2950
27.5 95 2560
33.7 75 2210
44.6 67 1850
32.9 100 2615
38.0 67 1965
24.2 120 2930
38.1 60 1968
39.4 70 2070
25.4 116 2900
31.3 75 2542
34.1 68 1985
34.0 88 2395
31.0 82 2720
27.4 80 2670
22.3 88 2890
28.0 79 2625
17.6 85 3465
34.4 65 3465
20.6 105 3380

 


1. the intercept ,
2. the slope coefficient , and
3. the standard error of the estimate. 
4. Using this model, predict the gasoline mileage for the car with 170 horsepower. Use all decimal places in your calculation by selecting and using the values of b0 and b1 in the output generated by Excel. 
5. Does the prediction involve extrapolating the relationship? Type yes or no. Use all decimal places in your calculation.
State the
6. lower bound 
7. upper bound for the 99% confidence interval for the slope coefficient

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution