Math (Prof. Frank ONLY)
Abnalldway
samplepr5.xlsxSheet1
| Salary | No. of employees ( f ) | Midpoint (Xm) | (Xm) 2 | f.Xm | f.( Xm ) 2 |
| 5001 - 10,000 | 11 | $ 7,500.50 | $ 56,257,500.25 | $ 82,505.50 | $ 618,832,502.75 |
| 10,001 - 15,000 | 13 | $ 12,500.50 | $ 156,262,500.25 | $ 162,506.50 | $ 2,031,412,503.25 |
| 15,001 - 20,000 | 20 | $ 17,500.50 | $ 306,267,500.25 | $ 350,010.00 | $ 6,125,350,005.00 |
| 20,001 - 25,000 | 17 | $ 22,500.50 | $ 506,272,500.25 | $ 382,508.50 | $ 8,606,632,504.25 |
| 25,001 - 30 ,000 | 13 | $ 27,500.50 | $ 756,277,500.25 | $ 357,506.50 | $ 9,831,607,503.25 |
| Total | 74 | ∑f X m | $ 1,335,037.00 | $ 27,213,835,018.50 | |
| (∑f X m ) 2 | $ 1,782,323,791,369.00 | ||||
| (∑f X m ) 2 / n | $ 24,085,456,640.12 | ||||
| s 2 = | $ 42,275,383.49 | (Variance) | |||
| SD= | $ 6,501.95 | ||||
| Population variance | |||||
| =∑f.Xm 2 – [( ∑fXm )2 / n] | |||||
| n |
