DSCI 346-01 F18: Chapter 12 On-Paper Assignment (40 points) Begin by re-writing the problem. Minitab is required; attach or include your output. Type your assignment (use Word); you may handwrite equations. You may want to refer to the Minitab handouts for Chapter 12 which may be found on Canvas under Chapter 12 Handouts under Modules. Use Data Set G, Mileage and Vehicle Weight, on page 536 of your textbook to answer the following questions. The data are found in the Excel Data file, MPG2, which is posted on Canvas under Modules under Chapter 12 Textbook data. The first column (Weight) is X, or the independent, variable and the second column (City MPG) is Y, or the dependent, variable. Use MINITAB to obtain the simple regression equation, confidence interval, prediction interval, and required graphs. Insert tables and graphs in your report as appropriate. Use Minitab and produce the appropriate output to answer the following questions. Attach the output. Construct a scatter plot. Recalling what scatter plots are used for, write a couple of sentences addressing what you observed from the plot. Be sure to relate your observations to the purpose of using scatter plots in regression. (4 points) 1. 2. Can we conclude that Weight of a vehicle helps in predicting City MPG? Follow the 7 steps for hypothesis testing. (12 points) Find the sample regression equation and interpret the coefficients. Remember your interpretations should be in terms of the problem. (4 points) 3. 4. Find the coefficient of determination, and interpret its value. (2 points) 5. Use residual analysis to check the validity of the model and fully explain your findings and conclusions. (6 Estimate with 95% confidence the average City MPG all vehicles with a weight of 3500 lbs. Predict with 95% confidence the City MPG for an individual vehicle with a weight of 3500 lbs. write at least one sentence using your confidence interval and at least one sentence using your prediction interval. (10 points) 6. Verify that the p-value for the F is the same as the slope t statistic’s p-value, and show that t F. (2 points) 7.