denomin

Percenta numerator of ator of

Xi (Yi- Xi(Xi-
S.No ge in Salary Yi-Ybar beta1(sum of Xi-Xbar beta1
Ybar) Xbar)
grade 10 col E) (sum of
col H) avg Y
1 62 270000 11808 732096 14653984.96 -1.9224 -119.1888 4763.7 258192
2 76.33 200000 -58192 -4441795 12.4076 947.0721
3 72 240000 -18192 -1309824 8.0776 581.5872
4 60 250000 -8192 -491520 -3.9224 -235.344
5 61 180000 -78192 -4769712 -2.9224 -178.2664
6 55 300000 41808 2299440 -8.9224 -490.732
7 70 260000 1808 126560 6.0776 425.432
8 68 235000 -23192 -1577056 4.0776 277.2768
9 82.8 425000 166808 13811702 18.8776 1563.065
10 59 240000 -18192 -1073328 -4.9224 -290.4216
11 58 250000 -8192 -475136 -5.9224 -343.4992
12 60 180000 -78192 -4691520 -3.9224 -235.344
13 66 428000 169808 11207328 2.0776 137.1216
14 83 450000 191808 15920064 19.0776 1583.441
15 68 300000 41808 2842944 4.0776 277.2768
16 37.33 240000 -18192 -679107 -26.5924 -992.6943
17 79 252000 -6192 -489168 15.0776 1191.13
18 68.4 280000 21808 1491667 4.4776 306.2678
19 70 231000 -27192 -1903440 6.0776 425.432
20 59 224000 -34192 -2017328 -4.9224 -290.4216
21 63 120000 -138192 -8706096 -0.9224 -58.1112
22 50 260000 1808 90400 -13.9224 -696.12
23 69 300000 41808 2884752 5.0776 350.3544
24 52 120000 -138192 -7185984 -11.9224 -619.9648
25 49 120000 -138192 -6771408 -14.9224 -731.1976
26 64.6 250000 -8192 -529203.2 0.6776 43.77296
27 50 180000 -78192 -3909600 -13.9224 -696.12
28 74 218000 -40192 -2974208 10.0776 745.7424
29 58 360000 101808 5904864 -5.9224 -343.4992
30 67 150000 -108192 -7248864 3.0776 206.1992
31 75 250000 -8192 -614400 11.0776 830.82
32 60 200000 -58192 -3491520 -3.9224 -235.344
33 55 300000 41808 2299440 -8.9224 -490.732
34 78 330000 71808 5601024 14.0776 1098.053
35 50.08 265000 6808 340944.6 -13.8424 -693.2274
36 56 340000 81808 4581248 -7.9224 -443.6544
37 68 177600 -80592 -5480256 4.0776 277.2768
38 52 236000 -22192 -1153984 -11.9224 -619.9648
39 54 265000 6808 367632 -9.9224 -535.8096
Salary
500000
450000
40 52 200000 -58192 -3025984 Salary
-11.9224 -619.9648
41 76 393000 134808 10245408
500000 12.0776 917.8976
42 64.8 360000 101808
4500006597158 0.8776 56.86848
43 74.4 300000 41808
4000003110515 10.4776 779.5334
44 74.5 250000 -8192
350000 -610304 10.5776 788.0312
45 73.5 360000 101808
3000007482888 9.5776 703.9536
46 57.58 180000 -78192 -4502295
250000
-6.3424 -365.1954
47 68 180000 -78192 -5317056
200000
4.0776 277.2768
48 69 270000 11808 814752 5.0776 350.3544
150000
49 66 240000 -18192 -1200672 2.0776 137.1216
100000
50 60.8 300000 41808 2541926 -3.1224 -189.8419
50000
0
30 40 50 60 70 80 90
 Yhat
error/
beta1 beta0 (fitted
residuals
values)
avg X
63.9224 3076.177 61555.36 252278.3 17721.67
296360 -96360
283040.1 -43040.1
246126 3874.02
249202.2 -69202.16
230745.1 69254.9
276887.8 -16887.75
270735.4 -35735.4
316262.8 108737.2
243049.8 -3049.803
239973.6 10026.37
246126 -66125.98
264583 163417
316878.1 133121.9
270735.4 29264.6
176389 63610.95
304573.3 -52573.34
271965.9 8034.133
276887.8 -45887.75
243049.8 -19049.8
255354.5 -135355
215364.2 44635.79
273811.6 26188.43
221516.6 -101517
212288 -92288
260276.4 -10276.39
215364.2 -35364.21
289192.5 -71192.46
239973.6 120026.4
267659.2 -117659
292268.6 -42268.64
246126 -46125.98
230745.1 69254.9
301497.2 28502.83
215610.3 49389.7
233821.3 106178.7
270735.4 -93135.4
221516.6 14483.44
227668.9 37331.08
 221516.6 -21516.56
295344.8 97655.19
260891.6 99108.37
290422.9 9577.071
290730.5 -40730.55
287654.4 72345.63
238681.6 -58681.63
270735.4 -90735.4
273811.6 -3811.573
264583 -24583
248586.9 51413.08

80 90
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.395367307
R Square 0.156315308
Adjusted R Square 0.138738543
Standard Error 71195.45557
Observations 50

ANOVA
df SS MS F Significance F
Regression 1 45078257910 4.51E+10 8.893293 0.0044866953
Residual 48 243302058890 5.07E+09
Total 49 288380316800

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%

Intercept 61555.35534 66701.9007666 0.922843 0.360705 -72557.80474 195668.5154
Percentage in grade 10 3076.177438 1031.52579781 2.982162 0.004487 1002.1558155 5150.19906
Lower 95.0% Upper 95.0%
-72557.80474 195668.51542
1002.1558155 5150.1990604