Question

In: Statistics and Probability

A US consumer lobby wishes to develop a model to predict gasoline usage, as measured by...

A US consumer lobby wishes to develop a model to predict gasoline usage, as measured by miles per gallon, based on the horsepower of the car's engine. The Excel data file AUTO.xls (contained in a folder under the CML Quizzes tab) contains data on this for fifty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, a 92% confidence interval for the slope coefficient and the residual plot. State all numerical answers below correct to four decimal places using the Excel output results. 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 120 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. State the 6. lower bound 7. upper bound for the 92% confidence interval for the slope coefficient.

Solutions

Expert Solution

ANSWER::

NOTE: Answers to the point are given below. For better understanding,

Back-up Theory and Details of Excel Calculations are given at the end.

Part (1)

the intercept = 50.0052 ANSWER 1

Part (2)

the slope coefficient – 0.2363 ANSWER 2

Part (3)

the standard error of the estimate

For intercept: 2.5235 ANSWER 3

For slope coefficient: 0.0226 ANSWER 4

Part (4)

Predicted value of the gasoline mileage for the car with 120 horsepower:

21.6522 mpg ANSWER 5

Part (5)

Does the prediction involve extrapolating the relationship? No. ANSWER 6

[because given x-values range from 48 to 165 and 120 is well within that range]

Part (6)

92% confidence interval for the slope coefficient

lower bound: - 0.2839 ANSWER 7

upper bound .- 0.1886 ANSWER 8

Back-up Theory

Let

y represent the gasoline usage, as measured by miles per gallon (i.e., MPG), and

x represent the horsepower of the car's engine.

The linear regression model Y = ?0 + ?1X + ?, ………………………………………..(1)

where ? is the error term, which is assumed to be Normally distributed with mean 0 and variance ?2.

Estimated Regression of Y on X is given by: Y = ?0cap + ?1capX, ………………………….(2)

where

?1cap = Sxy/Sxx and ?0cap = Ybar – ?1cap.Xbar..……………………………………………..(3)

Mean X = Xbar = (1/n)sum of xi ………………………………………….……………….(4)

Mean Y = Ybar = (1/n)sum of yi ………………………………………….……………….(5)

Sxx = sum of (xi – Xbar)2 …………………………………………………..………………………………..(6)

Syy = sum of (yi – Ybar)2 …………………………………………………..………………………………..(7)

Sxy = sum of {(xi – Xbar)(yi – Ybar)} …………………………………………………………………….………(8)

All above sums are over i = 1, 2, …., n

n = sample size ………………………………………………………………………………(9)

Estimate of ?2 is given by s2 = (Syy – ?1cap2Sxx)/(n - 2)……………………………………..(10)

Standard Error of ?1cap is sb, where sb2 = s2/Sxx

Standard Error of ?0cap is sa, where sa2 = sb2{(sum of xi2 over i = 1, 2, …., n)/n}

Standard Error of yicap = s?[(1/n) + {(xi – Xbar)2/Sxx}]

Now to work out the solution,

Details Excel Calculations:

n

50

xbar

90.84

ybar

28.542

Sxx

36408.72

Syy

3271.8418

Sxy

-8602.464

Slope coeff

-0.2363

intercept

50.0052

s^2

25.818669

s

5.0812

SE(slope coeff)

0.0266

SE(intercpt)

2.5235

tn-2,?/2

1.7885

CIbLB

-0.2839

CIbUB

-0.1886

DONE

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


Related Solutions

14.5 A consumer organization wants to develop a regression model to predict gasoline mileage (as measured...
14.5 A consumer organization wants to develop a regression model to predict gasoline mileage (as measured by miles per gallon) based on the horsepower of the car’s engine and the weight of the car, in pounds. A sample of 50 recent car models was selected, with the results recorded in the file auto.xls.                 a. State the multiple regression equation.                 b.   Interpret the meaning of the slopes, b1 and b2, in this problem.                 c.   Explain why the regression coefficient,...
1) A consumer organization wants to develop a regression model to predict gasoline mileage​ (as measured...
1) A consumer organization wants to develop a regression model to predict gasoline mileage​ (as measured by miles per​ gallon) based on the horsepower of the​car's engine and the weight of the car​ (in pounds). A sample of 20 recent car models was​ selected, with the results recorded in the accompanying table. MPG 15.3, 19.2, 20.1, 18.5, 17.5, 27.2, 44.6, 27.2, 28.0, 21.2, 28.0, 36.1, 20.1, 29.9, 36.0, 36.4, 33.7, 32.9, 24.2, 39.3 Horsepower - 190, 102, 142, 171, 166,67,64,82,91,...
Use the following data to develop a quadratic model to predict y from x. Develop a...
Use the following data to develop a quadratic model to predict y from x. Develop a simple regression model from the data and compare the results of the two models. Does the quadratic model seem to provide any better predictability? Why or why not? x y x y 15 229 15 247 9 74 8 82 6 29 5 21 21 456 10 94 17 320
14.1)use the following data to develop a quadratic model to predict y from x. develop a...
14.1)use the following data to develop a quadratic model to predict y from x. develop a simple regression model from the data and compare the results of the two models. Does the quadratic model seem to provide any better predictability? Why or why not ?       x       y         x       y 14 200 15 247 9 74 8 82 6 29 5 21 21 456 10 94 17 320 Answer:simple model: y^=   -14.27+27.128x, F=229.67 with p=.000, se=27.27, R2=.97,...
A real estate agent wants to develop a model to predict the selling price of a...
A real estate agent wants to develop a model to predict the selling price of a home. The agent believes that the most important variables in determining the price of a house are its: Size of the house (square footage) Number of bedrooms Lot size where the house is built (also in square feet). He collects from the market the data on a number of houses, which include for every house the information listed above as well as the house...
A teacher wants to develop a model to predict a student’s grade on the final exam...
A teacher wants to develop a model to predict a student’s grade on the final exam from the number of hours spent studying for the final exam and the student’s GPA at the university. The data (for 22 students) follows below.       PREDICTOR               COEF           STDEV               P-VALUE       Constant                      -1.30             1.429                0.405       Hours                           .0793            .0759                0.344       GPA                             1.11             .7543                0.202       ANOVA       SOURCE                                SS                     DF                 MS                F                                        Regression                             5.0040         ...
A teacher wants to develop a model to predict a student’s grade on the final exam...
A teacher wants to develop a model to predict a student’s grade on the final exam from the number of hours spent studying for the final exam and the student’s GPA at the university. The data (for 22 students) follows below.        PREDICTOR                 COEF             STDEV                       P-VALUE        Constant                         -1.30               1.429                          0.405        Hours                              .0793              .0759                          0.344        GPA                                1.11               .7543                          0.202        ANOVA        SOURCE                                    SS                               DF                   MS                  F                                                      Regression                                 5.0040                                                                     Error                                            1.1548                    TOTAL     (a) What is the student’s expected grade if she has a 2.7 GPA and she studies 12 hours for this test? (b) Interpret the slope coefficient for the variable...
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel Births 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel(y) Births(x) 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...
An electronics company is looking to develop a regression model to predict the number of units...
An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data is provided below: Sales (units) Price ($) Advertising ($) Holiday 500 100 50 Yes 480 120 40 Yes 485 110 45 No 510 103 55 Yes 490 108 40 No 488 109 30 No 496 106 45 Yes Compile a spreadsheet for the data and determine the predicted number of units sold if the watch is sold...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT