Scribd
Upload
2 views8 pages

Correlation Analysis of English and Science

The document presents a statistical analysis of the relationship between English scores and Science scores for a group of students, showing a high positive correlation (r = 0.78174). It includes regression statistics, ANOVA results, and residual outputs, indicating that English scores can predict Science scores with an intercept of approximately 3.33 and a slope of about 0.61. The analysis is based on 10 observations, with mean scores of 6 for English and 7 for Science.

Uploaded by

kean.servida
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2 views8 pages

Correlation Analysis of English and Science

The document presents a statistical analysis of the relationship between English scores and Science scores for a group of students, showing a high positive correlation (r = 0.78174). It includes regression statistics, ANOVA results, and residual outputs, indicating that English scores can predict Science scores with an intercept of approximately 3.33 and a slope of about 0.61. The analysis is based on 10 observations, with mean scores of 6 for English and 7 for Science.

Uploaded by

kean.servida
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Student English X Science Y x-xbar y-ybar (x-xbar)2

1 3 4 -3 -3 9
2 4 5 -2 -2 4
3 5 7 -1 0 1
4 5 7 -1 0 1
5 6 7 0 0 0
6 6 9 0 2 0
7 6 7 0 0 0
8 7 8 1 1 1
9 8 7 2 0 4
10 10 9 4 2 16
Total 60 70 36
Mean 6 7 S 2.000
r 0.78174
11 5 6 Se 0.974996

x
actual value 3
predicted value 3
(y-ybar)2 (x-xbar)(y-ybar)
9 9
4 4
0 0
0 0
0 0
4 0
0 0
1 1
0 0
4 8
22 22
1.563 2.444
High positive correlation

y
4
5.167
1.167
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.78174
R Square 0.611111111111111
Adjusted R Square 0.5625
Standard Error 1.03413947049924
Observations 10

ANOVA
df SS MS F
Regression 1 13.4444444444 13.444444444 12.571428571
Residual 8 8.55555555556 1.0694444444
Total 9 22

Coefficients Standard Error t Stat P-value


Intercept, A 3.33333333333333 1.0846146269 3.073288199 0.0152715497
English X, B 0.611111111111111 0.17235657842 3.5456210417 0.0075575807

RESIDUAL OUTPUT

Observation Predicted Science Y Residuals


1 5.16666666666667 -1.1666666667
2 5.77777777777778 -0.7777777778
3 6.38888888888889 0.61111111111
4 6.38888888888889 0.61111111111
5 7 0
6 7 2
7 7 0
8 7.61111111111111 0.38888888889
9 8.22222222222222 -1.2222222222
10 9.44444444444445 -0.4444444444
Engli
10
9 f(x) = 0.611111111111111
8
Significance F 7
0.0075575807 6

Science Y
5
4
3
Lower 95% Upper 95% Lower 95.0% Upper 95.0% 2
0.8322075186 5.8344591481 0.8322075186 5.8344591481 1
0.2136561286 1.0085660937 0.2136561286 1.0085660937
0
2 3 4 5 6
En
English X Line Fit Plot

f(x) = 0.611111111111111 x + 3.33333333333333

Science Y
Linear (Science Y)
Predicted Science Y

3 4 5 6 7 8 9 10 11
English X
ience Y)
Science Y
Student English X Science Y
1 3 4
2 4 5
3 5 7
4 5 7
5 6 7
6 6 9
7 6 7
8 7 8
9 8 7
10 10 9
English X Science Y

Mean 6 Mean 7
Standard Error 0.632455532 Standard Error 0.494413
Median 6 Median 7
Mode 6 Mode 7
Standard Deviation 2 Standard Deviation 1.563472
Sample Variance 4 Sample Variance 2.444444
Kurtosis 0.7351190476 Kurtosis 0.409091
Skewness 0.625 Skewness -0.654139
Range 7 Range 5
Minimum 3 Minimum 4
Maximum 10 Maximum 9
Sum 60 Sum 70
Count 10 Count 10

You might also like