Name:______________________________________ Module 5 Homework Assignment The paired data below consists of test scores and hours of preparation for 5 randomly selected students. Use this data set to answer the questions below: x Hours of preparation 5 2 9 6 10 y Test score 64 48 72 73 80 1. Use the given data to find the correlation coefficient r, regression equation and scatter plot in MS Excel. Solution: Instructor Comments: 2. Based on the linear correlation coefficient r, is this a good model? Explain. Solution: Instructor Comments: 3. What is the best predicted test score for a student who spent 7 hours preparing for the test? Solution: 4. Find the standard error Solution: Instructor Comments: se . Use formula or MS Excel. Instructor Comments: 5. Find the 99% prediction interval for the test score of a person who spent 7 hours preparing for the test. Solution: Instructor Comments: 6. Find the explained variation. Solution: Instructor Comments: 7. Find the unexplained variation. Solution: Instructor Comments: 8. Find the total variation. Solution: Instructor Comments: 9. Find the value of r2 and explain its meaning. Solution: Instructor Comments: 10. If the data point ( 3, 100) is added to the data set, how would this effect the results of the regression analysis? Is this data point an outlier, influential point or both? Explain. Solution: Instructor Comments