Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started