The paired data below consists of test scores and hours of preparation

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:

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
100% Originality
The main foundation of any academic writing company is offering 100% originality in their orders. Make your order today and benefit from anti-plagiarized papers.
Customer Support 24/7
You can rest assured that our customer support team is consistently available to solve any difficulties and take your orders 24/7.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.