2 Regression in Excel Go to Canvas Modules M22 In-Class Activity and...
70.2K
Verified Solution
Link Copied!
Question
Accounting
2 Regression in Excel Go to Canvas Modules M22 In-Class Activity and download the Excel dataset: mtcarsWTMPGonly . xlsx. The data was taken from a 1974 issue of the American magazine MotorTrend. It contains 12 variables on 32 different types of vehicles, but for this activity we'll only be using mpg and wt, the miles per US gallon and the weight (1000lbs), respectively. Recreate the regression output in part 1 by using the Data Analysis Toolpak in Excel. Then, answer the following questions: 8. What is the Sum of Squares Total, (yiy)2, of mpg? 9. What percentage of the variation in mpg can be explained by wt? 10. Carefully interpret the coefficient for wt. 11. Is the coefficient for wt statistically significantly different than 0 ? What value tells you this? 11. Compute the 95% confidence interval for the slope (the coefficient of wt). a. Compute the critical value. b. Compute the margin of error. c. State the confidence interval. 12. Compute the 90% confidence interval for the slope (the coefficient of wt). a. Compute the critical value. b. Compute the margin of error. c. State the confidence interval. 13. Interpret the 95% confidence interval
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
2 Regression in Excel Go to Canvas Modules M22 In-Class Activity and download the Excel dataset: mtcarsWTMPGonly . xlsx. The data was taken from a 1974 issue of the American magazine MotorTrend. It contains 12 variables on 32 different types of vehicles, but for this activity we'll only be using mpg and wt, the miles per US gallon and the weight (1000lbs), respectively. Recreate the regression output in part 1 by using the Data Analysis Toolpak in Excel. Then, answer the following questions: 8. What is the Sum of Squares Total, (yiy)2, of mpg? 9. What percentage of the variation in mpg can be explained by wt? 10. Carefully interpret the coefficient for wt. 11. Is the coefficient for wt statistically significantly different than 0 ? What value tells you this? 11. Compute the 95% confidence interval for the slope (the coefficient of wt). a. Compute the critical value. b. Compute the margin of error. c. State the confidence interval. 12. Compute the 90% confidence interval for the slope (the coefficient of wt). a. Compute the critical value. b. Compute the margin of error. c. State the confidence interval. 13. Interpret the 95% confidence interval 