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 
Other questions asked by students
Statistics
Q
The following selected account balances were taken from thetrial balance of Dallas Corporation as...
Accounting
Psychology
Basic Math
Calculus
Accounting
Accounting
Accounting