Question details

Module 9 Homework Assignment
$ 20.00

Module 9 Homework Assignment

SHOW ALL WORK!!

The paired data below consists of test scores and hours of preparation for 5 randomly selected students.

x    Hours of preparation      5     2     9      6   10

y Test score 64   48   72    73   80

 

1. Use the given data and MS Excel and find thecorrelation coefficient r, regression equation and scatter plot.
 

Solution:

 

 

Instructor Comments:

 

2. Based on the linear correlation coefficient r, and  a = 0.05, 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 the formula or Microsoft Excel Regression
 

Solution:

 

 

Instructor Comments:

 

5.  Find the 99% prediction interval for the test score of a person who spent 7hours preparing for the test given that E = 34.677. Interpret the result.
 

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 affect the results of the regression analysis?  Is this data point an outlier, influential point or both?  Explain.

Solution:

 

 

Instructor Comments:

 

 

Module 9 Homework Assignment

SHOW ALL WORK!!

The paired data below consists of test scores and hours of preparation for 5 randomly selected students.

x    Hours of preparation      5     2     9      6   10

y Test score 64   48   72    73   80

 

1. Use the given data and MS Excel and find thecorrelation coefficient r, regression equation and scatter plot.
 

Solution:

 

 

Instructor Comments:

 

2. Based on the linear correlation coefficient r, and  a = 0.05, 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 the formula or Microsoft Excel Regression
 

Solution:

 

 

Instructor Comments:

 

5.  Find the 99% prediction interval for the test score of a person who spent 7hours preparing for the test given that E = 34.677. Interpret the result.
 

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 affect the results of the regression analysis?  Is this data point an outlier, influential point or both?  Explain.

Solution:

 

 

Instructor Comments:

 

 

 

Available solutions