# 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 b_{0} and b_{1} 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