Correlation and Regression Analysis
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:
xHours of preparation529610
y Test score 6448727380
1. Use the given data to find the correlation coefficient r, regression equation and scatter plot in MS Excel.
Solution: |
2. Based on the linear correlation coefficient r, is this a good model?Explain.
Solution: |
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 . Use formula or MS Excel.
Solution: |
5.Find the 99% prediction interval for the test score of a person who spent 7 hours preparing for the test given that E=34.677. Interpret the result.
Solution: |
6.Find the explained variation.
Solution: |
7.Find the unexplained variation.
Solution: |
8.Find the total variation.
Solution: |
9.Find the value of r2 and explain its meaning.
Solution: |
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: |