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 Calculation form to Locate Decile and Quartile
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