Description
please download the Microsoft Word document using the link below and follow the directions included in the assignment.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hi,Find attached the completed work.Feel free to ask for any clarification or editing if need be.Looking forward to working with you in the future.Thank you.
Name: ______________________________________
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
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:
Correlation Coefficient (r) = 0.9241
Regression equation: y = 44.84 + 3.52x
Scatter Plot
Instructor Comments:
100
0
0
5
10
15
2. Based on the linear correlation coefficient r, is this a good model? Explain.
Solution:
r = 0.9241
This is a good model. It indicates a strong positive
correlation between the two variables. They are
moving in the same direction. An increase in the
number of hours used for preparation causes an
increase in the test score.
Instructor Comments:
3. What is the best predicted test score for a student wh...