Linear Correlation, statistics assignment help

User Generated

QvnUrnq

Mathematics

Description

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:

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 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:


User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please see attached. Thanks!

x
y

Hours of Preparation
Test Score
Predicted value of y (y^)
y^-mean(y)
y^-mean(y) squared
y...


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags