Example of Formula Application
Below you have an example of formula application for salary data of System Analyst position of companies X, Y, Z and corrected for 240 monthly hours for same data-base:
Companies |
X |
Y |
Z |
|||
Frequency |
Salary |
Frequency |
Salary |
Frequency |
Salary |
|
Frequency Data (Frequency) and Salary (Sal.). |
1 |
1,000.00 |
1 |
1,000.00 |
1 |
1,200.00 |
2 |
1,200.00 |
1 |
1,300.00 |
|
|
|
1 |
1,250.00 |
|
|
|
|
Sf |
Xi |
XiSf |
Xi2Fi |
2 |
1,000.00 |
2,000 |
2000000 |
3 |
1,200.00 |
3,600 |
4320000 |
1 |
1,250.00 |
1,250 |
1562500 |
1 |
1,300.00 |
1,300 |
1690000 |
7 |
4,750.00 |
8,150 |
9572500 |
Sample Scope
Class Scope
Classes |
Frequency Simple |
Frequency Accrued |
1000 - 1075 |
2 |
2 (1st Decile, 1st Quartile) |
1075 - 1150 |
0 |
2 (Median) |
1150 - 1225 |
3 |
5 |
1225 - 1300 |
2 |
7 (3rd Quartile, 9th Quartile) |
See Also
| • | See formulas and calculation of Decile and Quartile |
Result of System Analyst position can be transcribed according to presentation below:
Position: System Analyst |
|
1st Decile |
1026.25 |
1st Quartile |
1065.62 |
Median |
1187.50 |
3rd Quartile |
1234.37 |
9th Decile |
1273.75 |
Average |
1164.28 |
Frequency |
7 |