In: Statistics and Probability
Student Hours Studied Exam Grade
Barbara 4 5
Bob 1 2
Diane 3 1
Owen 5 5
Charles 8 9
Ed 2 7
Sanford 7 6
Summer 6 8
(a) We input the data set in Excel and use the CORREL function
to compute the correlation coefficient value. The value =
0.6832.
(b) This correlation coefficient value tells us that there is a
moderate, positive association between the variables Hours Studied
and Grade. This further tells us that as the number of hours
studied increases, the grades also increase and vice versa.
(c) We are to test whether there exists a real association between
Hours Studied and Grade. Here,
= population correlation coefficient.