Points = f(Absences) Example          P=F(A)

 
X
Y
Y-Ybar
X-Xbar
(X-Xbar)2
((X-Xbar)(Y-Ybar)
A=Absences
P=Points
P-Pbar
A-Abar
(A-Abar)2
(A-Abar)(P-Pbar)
2
327
36.33
-1.5
2.25
-54.50
6
276
-14.67
2.5
6.25
-36.67
7
269
-21.67
3.5
12.25
-75.83
3
246
-44.67
-0.5
0.25
22.33
1
327
36.33
-2.5
6.25
-90.83
2
299
8.33
-1.5
2.25
-12.50
29.50
-248.00
Means
3.5
290.67

 
 
Beta 1 hat =(-248)/29.5 =
-8.41
Beta 0 hat =290.67 - (-8.4)(3.5) =
320.07

P hat = 320.07 - 8.41 A


Regression Statistics
Multiple R
0.62
R Square
0.39
Adjusted R Square
0.23
Standard Error
28.74
Observations
6
ANOVA
df
SS
MS
F
Significance F
Regression
1
2084.88
2084.88
2.52
0.19
Residual
4
3304.45
826.11
Total
5
5389.33
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
320.09
21.93
14.60
0.00
259.22
380.97
A=Absences
-8.41
5.29
-1.59
0.19
-23.10
6.29