Author:
Christine Farr

Module 5 Homework AssignmentThe paired data below consists of test scores and hours of preparation for 5 randomly selectedstudents. Use this data set to answer the questions below:x Hours of preparation 5 2 9 6 10y Test score64 48 72 73 801. Use the given data to find the correlation coefficient r, regression equation and scatter plot in MSExcel.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 errorSolution: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 thetest. 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 regressionanalysis? Is this data point an outlier, influential point or both? Explain.Solution:

Tutorial