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].

Explain your reasoning.

Homework Answers

Answer #1

ANSWER::

  

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

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
SUMMARY OUTPUT Regression Statistics Multiple R 0.881644384 R Square 0.77729682 Adjusted R Square 0.767919844 Standard Error...
SUMMARY OUTPUT Regression Statistics Multiple R 0.881644384 R Square 0.77729682 Adjusted R Square 0.767919844 Standard Error 2.046234994 Observations 100 ANOVA df SS MS F Significance F Regression 4 1388.337623 347.0844058 82.89418891 3.94359E-30 Residual 95 397.7723769 4.187077651 Total 99 1786.11 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 30.46621607 3.539611332 8.607220742 1.55786E-13 23.43919912 37.49323302 23.43919912 37.49323302 Engine size -0.026439837 0.008914999 -2.965769936 0.003818268 -0.044138349 -0.008741326 -0.044138349 -0.008741326 Compression Ratio 0.364901894 0.056081385 6.506649162 3.58903E-09 0.253566269 0.476237519...
The following data was collected to explore how the average number of hours a student studies...
The following data was collected to explore how the average number of hours a student studies per night and the student's GPA affect their ACT score. The dependent variable is the ACT score, the first independent variable (x1) is the number of hours spent studying, and the second independent variable (x2) is the student's GPA. ACT Score Study Data Study Hours GPA ACT Score 1 2 19.91 1 2 19.69 2 2 25.52 2 3 29.67 2 4 29.77 A...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both on business and for pleasure. As part of a comprehensive research effort undertaken by a New York marketing research firm on behalf of American Express, a study was conducted to determine the relationship between miles traveled (x) and charges made on the American Express card (y). Eight cardholders were randomly selected and their total charges recorded for a specified period. A questionnaire was then...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both on business and for pleasure. As part of a comprehensive research effort undertaken by a New York marketing research firm on behalf of American Express, a study was conducted to determine the relationship between miles traveled (x) and charges made on the American Express card (y). Eight cardholders were randomly selected and their total charges recorded for a specified period. A questionnaire was then...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both on business and for pleasure. As part of a comprehensive research effort undertaken by a New York marketing research firm on behalf of American Express, a study was conducted to determine the relationship between miles traveled (x) and charges made on the American Express card (y). Eight cardholders were randomly selected and their total charges recorded for a specified period. A questionnaire was then...
Question 1 The travel agency Paradise Retreats has developed a model to predict the price per...
Question 1 The travel agency Paradise Retreats has developed a model to predict the price per night of holiday apartment rentals in the coast of Croatia: ?=550+11?1−5?2 ?: price of the apartment per night (in kunas) ?1: area of the apartment (in square meters) ?2: distance to the beach (in km) According to Paradise Retreats’ model: How much more expensive (in kunas) will be the rental of a 60 square-meter apartment on the beachfront compared with a 60 square-meter apartment...