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
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
Save your time  order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Nowy 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:

Instructor Comments: 
4. Find the standard error . Use formula or MS Excel.
Solution:

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 r^{2} 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: 