In: Statistics and Probability
The data below shows data collected at the end of a statistics class to investigate the relationship between x = study time per week (average number of hours) and y = college GPA. The table shows the data for the 8 males in the class on these variables and on the number of class lectures of the course that the student reported skipping during the term.
Is there a statistically significant correlation between study time and GPA at the .05 significance level? If yes what is the p-value?
If there is a statistically significant correlation what would the formula be to predict GPA based on study time?
If there is a statistically significant correlation what would the GPA be estimated for studying 0 hours?
If there is a statistically significant correlation what would the GPA be estimated for studying 9 hours?
| Student | Study time | GPA | Skipped | 
| 1 | 14 | 2.8 | 9 | 
| 2 | 25 | 3.6 | 0 | 
| 3 | 15 | 3.4 | 2 | 
| 4 | 5 | 3 | 5 | 
| 5 | 10 | 3.1 | 3 | 
| 6 | 12 | 3.3 | 2 | 
| 7 | 5 | 2.7 | 12 | 
| 8 | 21 | 3.8 | 1 | 
| x | y | (x-x̅)² | (y-ȳ)² | (x-x̅)(y-ȳ) | 
| 14 | 2.8 | 0.3906 | 0.1702 | -0.2578 | 
| 25 | 3.6 | 135.1406 | 0.1502 | 4.5047 | 
| 15 | 3.4 | 2.6406 | 0.0352 | 0.3047 | 
| 5 | 3 | 70.1406 | 0.0452 | 1.7797 | 
| 10 | 3.1 | 11.3906 | 0.0127 | 0.3797 | 
| 12 | 3.3 | 1.8906 | 0.0077 | -0.1203 | 
| 5 | 2.7 | 70.1406 | 0.2627 | 4.2922 | 
| 21 | 3.8 | 58.1406 | 0.3452 | 4.4797 | 
| ΣX | ΣY | Σ(x-x̅)² | Σ(y-ȳ)² | Σ(x-x̅)(y-ȳ) | |
| total sum | 107.00 | 25.70 | 349.88 | 1.03 | 15.36 | 
| mean | 13.38 | 3.21 | SSxx | SSyy | SSxy | 
correlation coefficient ,    r = Sxy/√(Sx.Sy)
=   0.8097
yes, there a statistically significant correlation between study time and GPA at the .05 significance lev
Ho:   ρ = 0  
Ha:   ρ ╪ 0  
n=   8  
alpha,α =    0.05  
correlation , r=   0.8097  
t-test statistic = r*√(n-2)/√(1-r²) =   
    3.380
DF=n-2 =   6  
p-value =   
0.0149  
--------------
Ŷ =   2.625   +  
0.044   *x
-------------------
Predicted Y at X=   0   is  
       
Ŷ =   2.6252   +  
0.0439   *0=   2.625
-------------------------
Predicted Y at X=   9  
is          
Ŷ =   2.6252   +  
0.0439   *9=   3.020