SUMMARY OUTPUT

Regression Statistics
Multiple R 0.743213369
R Square 0.552366112
Adjusted R Square 0.515063288
Standard Error 2.278834352
Observations 14

ANOVA
df SS MS F Significance F
Regression 1 76.89725367 76.89725367 14.80762183 0.002318275
Residual 12 62.31703204 5.193086003
Total 13 139.2142857

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
Intercept 50.91905565 9.748107113 5.223481345 0.000213492 29.67975481 72.15835649 29.67975481 72.15835649
X Variable 1 1.347386172 0.350146209 3.848067285 0.002318275 0.58448312 2.110289225 0.58448312 2.110289225

RESIDUAL OUTPUT

Observation Predicted Y Residuals

1 84.60370995 2.396290051
2 84.60370995 -0.603709949
3 85.95109612 -0.951096121
4 85.95109612 2.048903879
5 87.29848229 -5.298482293
6 87.29848229 -0.298482293
7 88.64586847 2.354131535
8 88.64586847 0.354131535
9 89.99325464 -0.993254637
10 89.99325464 -2.993254637
11 89.99325464 2.006745363
12 91.34064081 1.659359191
13 91.34064081 -0.340640809
14 91.34064081 0.659359191
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.743213
R Square 0.552366
Adjusted R Square 0.515063
Standard Error 3.418252
Observations 14

ANOVA
df SS MS F Significance F
Regression 1 173.0188 173.0188 14.80762 0.002318
Residual 12 140.2133 11.68444
Total 13 313.2321

Coefficients
Standard Error t Stat P-value Lower 95% Upper 95%Lower 95,0%
Upper 95,0%
Intercept 76.37858 14.62216 5.223481 0.000213 44.51963 108.2375 44.51963 108.2375
X Variable 1 1.347386 0.350146 3.848067 0.002318 0.584483 2.110289 0.584483 2.110289

RESIDUAL OUTPUT

Observation Predicted Y Residuals

1 126.9056 3.594435
2 126.9056 -0.90556
3 128.9266 -1.42664
4 128.9266 3.073356
5 130.9477 -7.94772
6 130.9477 -0.44772
7 132.9688 3.531197
8 132.9688 0.531197
9 134.9899 -1.48988
10 134.9899 -4.48988
11 134.9899 3.010118
12 137.011 2.489039
13 137.011 -0.51096
14 137.011 0.989039
 a b c
No X Y Xbar Ybar xi - xbar yi - ybar ab sigma ab Covariance sqr a
1 25 87 27.78571 88.35714 -2.78571 -1.35714 3.780612245 57.07142857 4.39010989 7.76020408
2 25 84 -2.78571 -4.35714 12.1377551 7.76020408
3 26 85 -1.78571 -3.35714 5.994897959 3.18877551
4 26 88 0.743213 -1.78571 -0.35714 0.637755102 3.18877551
5 27 82 -0.78571 -6.35714 4.994897959 0.61734694
6 27 87 -0.78571 -1.35714 1.066326531 0.61734694
7 28 91 0.214286 2.642857 0.566326531 0.04591837
8 28 89 0.214286 0.642857 0.137755102 0.04591837
9 29 89 1.214286 0.642857 0.780612245 1.4744898
10 29 87 1.214286 -1.35714 -1.647959184 1.4744898
11 29 92 1.214286 3.642857 4.423469388 1.4744898
12 30 93 2.214286 4.642857 10.28061224 4.90306122
13 30 91 2.214286 2.642857 5.852040816 4.90306122
14 30 92 Xbar Ybar 2.214286 3.642857 8.066326531 4.90306122
37.5 130.5 41.67857 132.5357 -4.17857 -2.03571 8.506377551 128.4107143 9.877747253 17.4604592
37.5 126 -4.17857 -6.53571 27.30994898 17.4604592
39 127.5 -2.67857 -5.03571 13.48852041 7.1747449
39 132 -2.67857 -0.53571 1.43494898 7.1747449
40.5 123 -1.17857 -9.53571 11.23852041 1.38903061
40.5 130.5 -1.17857 -2.03571 2.399234694 1.38903061
42 136.5 0.321429 3.964286 1.274234694 0.10331633
42 133.5 0.321429 0.964286 0.30994898 0.10331633
43.5 133.5 1.821429 0.964286 1.756377551 3.31760204
43.5 130.5 1.821429 -2.03571 -3.707908163 3.31760204
43.5 138 1.821429 5.464286 9.952806122 3.31760204
45 139.5 3.321429 6.964286 23.13137755 11.0318878
45 136.5 3.321429 3.964286 13.16709184 11.0318878
45 138 3.321429 5.464286 18.14923469 11.0318878
 d
sqr b sum c sum d stdev X stdev Y Correlation t CV b a Y hat SE SSE
1.841837 42.3571429 139.2143 1.80506004 3.27242895 0.74321337 3.848067 2.179 1.347386 50.91906 84.60371 5.742206 62.31703
18.98469 84.60371 0.364466
11.27041 85.9511 0.904584
0.127551 85.9511 4.198007
40.41327 Y = 50,9 + 1,34X 87.29848 28.07391
1.841837 87.29848 0.089092
6.984694 88.64587 5.541935
0.413265 88.64587 0.125409
0.413265 89.99325 0.986555
1.841837 89.99325 8.959573
13.27041 89.99325 4.027027
21.55612 91.34064 2.753473
6.984694 91.34064 0.116036
13.27041 91.34064 0.434755
4.144133 95.3035714 313.2321 2.70759006 4.90864342 0.74321337
42.71556
25.35842
0.28699
90.92985
4.144133
15.71556
0.929847
0.929847
4.144133
29.85842
48.50128
15.71556
29.85842
Standar Error of Estimate
2.278834352
26 85
26 88
27 82 0.743213
25 87
28 91
28 89
29 89
27 87
29 92
30 93
30 91
30 92
25 84
29 87
Age Sales
25 87 14.29412
25 84 0.901609
26 85
26 88
26 89
27 82
27 87
28 91
28 88
28 89
28 90 105
29 89
29 87 100
29 92

Sales Achievememt
30 93
95
30 95
30 91
30 92 90
31 89
31 95 85
31 94
32 96
80
32 95 23 25 27 29 31
33 94
Salesperson's
33 98 Age
33 97
33 95
34 99
34 100
34 98
35 97
27 29 31 33 35 37 39
Salesperson's
Age
35 97
36 98
37 99
 25 87 4.39011
150
25 84 0.743213
26 85
26 88
27 82 140

27 87
28 91
28 89 130
29 89
29 87
29 92 120
30 93
30 91
30 92 110
37.5 130.5 9.877747
37.5 126 0.743213
39 127.5 100
39 132
40.5 123
40.5 130.5 90
42 136.5
42 133.5
43.5 133.5
80
43.5 130.5
43.5 138
45 139.5
70
45 136.5 20 25 30 35 40
45 138
35 40 45 50
Jumlah Polisi Jumlah Kejahatan
50 174 57.17647
50 168 0.901609
52 170
52 176
52 178
54 164
54 174
56 182
56 176
56 178
56 180 220
58 178
200
58 174
58 184

Sales Achievememt
180
60 186
60 190 160
60 182
140
60 184
62 178 120
62 190
62 188 100
64 192
80
64 190 23 33 43
66 188
66 196
66 194
66 190
68 198
68 200
68 196
70 194
33 43 53 63 73 83
Salesperson's
Age
70 194
72 196
74 198