Worksheat: Linear Regression Analysis

Results

cases [i]

X

Y

Xi-
SSx =
(Xi-)2
Yi-
SSy =
(Yi-)2
Cross Productxy =
(Xi-) * (Yi-)

1

0
-1.02
-0.5
0.25
-1.160
1.344
0.580

2

0

1.42

-0.5
0.25
1.281
1.640
-0.640

3

0

-0.26

-0.5
0.25
-0.400
0.160
0.200

4

0

-0.05

-0.5
0.25
-0.190
0.036
0.095

5

0
1.86
-0.5
0.25
1.721
2.960
-0.860

6

0
0.68
-0.5
0.25
0.541
0.292
-0.270
7
0
0.05
-0.5
0.25
-0.090
0.008
0.045
8
0

0.27

-0.5
0.25
0.131
0.017
-0.065
9
0
2.47
-0.5
0.25
2.331
5.431
-1.165

10

0

-1.39

-0.5
0.25
-1.530
2.339
0.765
11
1
-0.84
0.5
0.25
-0.980
0.959
-0.490
12
1
0.12
0.5
0.25
-0.020
0.000
-0.010
13
1
-0.57
0.5
0.25
-0.710
0.503
-0.355
14
1
-1.09
0.5
0.25
-1.230
1.512
-0.615
15
1
0.21
0.5
0.25
0.071
0.005
0.035
16
1
-0.13
0.5
0.25
-0.270
0.073
-0.135
17
1
0.94
0.5
0.25
0.801
0.641
0.400
18
1
0.87
0.5
0.25
0.731
0.534
0.365
19
1
-0.35
0.5
0.25
-0.490
0.240
-0.245
20
1
-0.40
0.5
0.25
-0.540
0.291
-0.270

Σ =

10
2.79
5.00
18.985
-2.635
Source
Degrees of Freedom (df)
Sum of Squares (SS)
Mean Square (MS)
F-ratio
Significance
Regression 

1

1.3887

1.3887

1.4205

0.2488

Error 

18

17.5965

0.9776

Total 

19

18.9851


last modified: 2/1/10