Description
Using Excel graph a scatterplot of the data. (4p)
Describe the type of correlation and interpret the correlation in the context of the data. Be specific in describing the magnitude, direction, and strength of the relationship.
Calculate the sample correlation coefficient for the data. (Pearson correlation coefficient between hours spent studying, x, and test score, y). (Round your final answer to three decimal places). (7p)
Show all work and outputs in excel as well as on each question. Can typed on word docs. The excel scatter plot must include all the outputs. All directions and questions are included in attachment below.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

Hello buddy! I have attached the answer in a word document for you. Also, there is an outline. :) Let me know if you have any edits or have any questions.
Last Name 1
Name
Instructor's name
Course
Date
Homework #5 Statistics
The number of hours 9 students spent studying for a test and their scores on that test is
represented in the table below.
Hours spent studying, x
Test scores, y
0
2
4
5
5
5
6
7
8
40
51
64
69
73
75
93
90
95
Question 1
Using Excel graph a scatterplot of the data. (4p)
Answer
The scatterplot for the data is as shown below:
Scatter Plot
100
90
80
Test scores, y
70
60
50
40
30
20
10
0
0
1
2
3
4
5
6
Hours spent studying, x
7
8
9
Last Name 2
Question 2
Describe the type of correlation and interpret the correlation in the context of the data. Be
specific in describing the magnitude, direction, and strength of the relationship. (6p)
Answer
The data has a strong positive linear correlation which is indicated by increase in the value
of the Test scores (y-variable) as a result of the increase in the value of the hours spent
studying (x-variable). The magnitude of the correlation is given by the correlation
coefficient (r=0.9685). The correlation is positive since the y-values increase as the xvalues increase. The correlation is almost perfect as indicated by the plot with all points
lying almost on a straight line on a scatter diagram and hence the strength is a strong
correlation (r≈1).
Question 3
Calculate the sample correlation coefficient for the data. (Pearson correlation coefficient
between hours spent studying, x, and test score, y). (Round your final answer to three
decimal places). (7p)
Answer
The table below is used to calculate the sample correlation coefficient for the data:
x
Y
𝑥 − 𝑥̅
0
40
-4.667 -
𝑦 − 𝑦̅
(𝑥 − 𝑥̅ )(𝑦 − 𝑦̅)
(𝑥 − 𝑥̅ )2
(𝑦 − 𝑦̅)2
150.370
21.778
1038.272
56...
