Question

# Question 4: Analysts at a major automobile company collected data on a variety of variables for...

Question 4: Analysts at a major automobile company collected data on a variety of variables for a sample of 30 different cars and small trucks.  Included among those data were the EPA highway mileage rating and the horsepower of each vehicle.  The analysts were interested in the relationship between horsepower (x) and highway mileage (y). Given below is the Excel output from regressing starting miles per gallon (MPG) on number of horsepower for a sample of 30 students.

Note: Some of the numbers in the output are purposely erased.

 Regression Statistics Multiple R 0.5493 R Square 0.3016 Adjusted R Square 0.2766 Standard Error 3.5532 Observations 30 ANOVA df SS MS F Significance F Regression 1 152.655 12.091 12.091 Residual 12.625 Total 30 506.167 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 31.1658 1.9332 16.12 0.0000 27.2058 35.1258 Horsepower -0.0286 0.0082 -3.4772 0.0017 -0.0454 -0.0117

a) What is the estimated average change in MPG as a result of an extra unit of horsepower?

b) What is the value of the measured t-test statistic and its p-value to test whether average MPG depends linearly on Horsepower?

c) What is the error sum of squares (SSE) of the above regression? Show how you obtain your answer.

f) The 99% confidence interval for the average change in MPG as a result of increased horsepower is:

A) wider than [-0.0454, -0.0117].

B) narrower than [-0.0454, -0.0117].

C) wider than [27.2058, 35.1258].

D) narrower than [27.2058, 35.1258].

Option:: (B) is correct......... narrower than [-0.0454, -0.0117]

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Need Online Homework Help?

Most questions answered within 1 hours.