Question

1. Provide answers for each prompt.
   1. Scatter plot (copy and paste)
   2. Find correlation coefficient using Excel
   3. Find means and standard deviations of Reading score and Math score.
   4. Interpret the result (regarding the correlation).

Reading score	Math score
45	102
40	100
48	106
45	101
38	98
43	100
36	92
41	102
42	102
50	110
43	104
50	108
42	96
40	99
41	96
48	102
47	104
37	94
42	98
45	100

Reading Score Mean=	Math Score Mean=
Reading score SD=	Math Score SD=
Correlation Coefficient (r)=
Interpret Correlation Coefficient

Copy and paste your scatter plot from Excel.

Answer 1

​​​​​​mean calculated using Excel formula (=average())

Standard deviation using (=STDEV.P())

Correlation using (=correl())

Mean reading score=43.15 .

Reading score SD=3.870215941

Mean math score =100.7

Math score SD= 4.254969084

Correlation coefficient (r)= 0.864320899

Since , there exist a strong positive correlation between reading and math score so reading score increases with increase in math score and vice versa .

Scatterplot has plotted . Indicating positive correlation between math score and reading score .