The fuel economy spreadsheet https://instructure-uploads.s3.amazonaws.com/accoun

Question

The fuel economy spreadsheet https://instructure-uploads.s3.amazonaws.com/account_300000000089332/attachments/57520639/Fuel%20Economy%20Model.xlsx?response-content-disposition=attachment%3B%20filename%3D%22Fuel%20Economy%20Model.xlsx%22%3B%20filename%2A%3DUTF-8%27%27Fuel%2520Economy%2520Model.xlsx&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAJFNFXH2V2O7RPCAA%2F20170723%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20170723T195441Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&X-Amz-Signature=3bff54d65c1837be67eb2605ed8f7dce4d3b3ca9c7be1f3eece4daaa855f9d9a ontains data on 309 automobiles the field includes manufacturer engine displacement grade of gasoline used to feel economy. Build a regression model using displacement and fuel type to predict highway mpg your model should have an orange Square equal to 0.684940889. Use the regression model output to answer these 3 questions 1. What is the value of the test statistic use to test the null hypothesis Ho:B1=B2=0 Vs. The alternative that at least one of the coefficient is not equal to zero? Round your answer to one decimal place. 2. An automobile using regular gasoline will get, on average, how many more miles per gallon that an automobile with the same engine displacement that uses premium gasoline? Round to two decimal places 3. What is the predicted MPG for an automobile with a 2.0 L engine that uses regular gasoline? Round answer to one decimal place. The fuel economy spreadsheet https://instructure-uploads.s3.amazonaws.com/account_300000000089332/attachments/57520639/Fuel%20Economy%20Model.xlsx?response-content-disposition=attachment%3B%20filename%3D%22Fuel%20Economy%20Model.xlsx%22%3B%20filename%2A%3DUTF-8%27%27Fuel%2520Economy%2520Model.xlsx&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAJFNFXH2V2O7RPCAA%2F20170723%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20170723T195441Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&X-Amz-Signature=3bff54d65c1837be67eb2605ed8f7dce4d3b3ca9c7be1f3eece4daaa855f9d9a ontains data on 309 automobiles the field includes manufacturer engine displacement grade of gasoline used to feel economy. Build a regression model using displacement and fuel type to predict highway mpg your model should have an orange Square equal to 0.684940889. Use the regression model output to answer these 3 questions 1. What is the value of the test statistic use to test the null hypothesis Ho:B1=B2=0 Vs. The alternative that at least one of the coefficient is not equal to zero? Round your answer to one decimal place. 2. An automobile using regular gasoline will get, on average, how many more miles per gallon that an automobile with the same engine displacement that uses premium gasoline? Round to two decimal places 3. What is the predicted MPG for an automobile with a 2.0 L engine that uses regular gasoline? Round answer to one decimal place. 1. What is the value of the test statistic use to test the null hypothesis Ho:B1=B2=0 Vs. The alternative that at least one of the coefficient is not equal to zero? Round your answer to one decimal place. 2. An automobile using regular gasoline will get, on average, how many more miles per gallon that an automobile with the same engine displacement that uses premium gasoline? Round to two decimal places 3. What is the predicted MPG for an automobile with a 2.0 L engine that uses regular gasoline? Round answer to one decimal place.

Explanation / Answer

1) TS =   332.6231568 = 332.6

2) the model is mpg ^ =b0 + b1*fuel + b2* displacement

fuel = 1 for premium else 0

hence required answer is b1

= -2.722958426

3) here displacement = 2 , fuel = 0 {Regular

hence

MPG^ =   40.59456529 - 3.194400513 *2

= 34.2057642

=34.21

Please don't forget to rate positively if you found this response helpful.
Feel free to comment on the answer if some part is not clear or you would like to be elaborated upon.
Thanks and have a good day!

SUMMARY OUTPUT Regression Statistics Multiple R 0.827611557 R Square 0.684940889 Adjusted R Square 0.682881679 Standard Error 3.20679604 Observations 309 ANOVA df SS MS F Significance F Regression 2 6841.08764 3420.543818 332.6231568 1.79466E-77 Residual 306 3146.7635 10.28354084 Total 308 9987.85113 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 40.59456529 0.4906405 82.73790111 1.8206E-211 39.62910905 41.56002 39.62911 41.56002154 Fuel -2.722958426 0.42217481 -6.449836298 4.36512E-10 -3.553691535 -1.89223 -3.55369 -1.892225317 Displacement -3.194400513 0.1701453 -18.77454467 7.43392E-53 -3.529203369 -2.8596 -3.5292 -2.859597656

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.