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
A basket contains three apples, three peaches, and four pears. You randomly select a piece...
In 1919, Pasha Patel owned several acres of land in the Upper Peninsula of Michigan. Half...
Twenty nine concrete blocks were sampled and tested for crushing strength in order to estimate...
ed the EAI sampling problem the population mean is 71 300 and the population standard...
You can work at most 20 hours next week You need to earn at least...
Perform a vertical analysis on the following information. (Round your answers...
On December 1,2025 Blossom Distributing Company had the following account balance
answer is 6,254,000.00 need help doing work A firm has current liabilities of $30.6...
4. 5 pts) Suppose we made a forward contract with delivery price K on a...
This scenario applies to Questions 5 and 6. A buyer wants to know...