Modify Percentiles

<< Click to Display Table of Contents >>

Navigation:  Additional Salary Assessor Topics (Listed Alphabetically) >

Modify Percentiles

To Change the Percentiles or Mean/Median/Levels

1.From the Job Report, Benchmark List, Geographic List, Advanced Reports, Pay Grades (in Compensation Management), or Market Pricing sub-tab in Survey Management, click Percentiles.
From the Employee List (in Compensation Management), click Table Tools and select Percentiles.
2.In the Modify Percentiles dialog, select the desired percentiles, mean/median, or levels using the drop-down menus:

For the Low Percentile(s), you may select range minimum percentiles between the 10th percentile and the 45th percentile.  

For the Average, you may select Mean, Median, or Levels. (Modify Percentiles does not display Levels under Average in Job Report, Employee List, or Survey Management.)  See details on Levels below.

For the High Percentile(s), you may select range maximum percentiles between the 55th percentile and the 90th percentile.

3.If you have selected Annual (default) as the Pay Period, then you may select Display in Thousands.  If selected, this will display a value of 97,331 as 97.3, for example.  (This option is available on all pages except Compensation Management).

4.For Advanced Reports, you may check the box to include both mean and median in the Export to Excel (available in Very Wide format only).

5.Select Default to reset the percentiles to 10th, 25th, mean, 75th, and 90th percentiles in Job Report, Benchmark List, Geographic List, Advanced Reports OR the 25th, mean, and 75th percentiles in Compensation Management OR the Market Pricing sub-tab in Survey Management.

6.For the Employee List (in Compensation Management), select the Default Market Rate from the drop-down menu. The Default Market Rate specified will be used in Market Index calculations. Values that rely on Market Index calculations, including those related to Market Index Merit Rewards plans, will also be impacted:

Low Percentile

Average

High Percentile

7.Click OK.

 

See Percentiles and Mean/Median for definitions of terms and more background information.

 

Levels

In the Benchmark List, Geographic List, Advanced Reports, and Compensation Management, the Salary Assessor now allows for the reporting of compensation for the selected job based on level when a location in the Extended Geographic Database is selected (see Browse Areas). Job Report reports salaries by level for all locations, including both the Primary Geographic Database and the Extended Geographic Database, though the display of data varies according to the database selected.  Salaries by level are only reported for non-executive jobs. Director and executive jobs will display salaries by the size of the organization, reported as Small, Medium/Large, and Large/Very Large, when a location in the Extended Geographic Database is selected. For locations in the Primary Geographic Database, director and executive jobs will display average salaries based on parameters selected in the Organization Data panel (e.g., location, industry, and organization size). Tables that include both non-executive and director/executive jobs will display Low/Medium/High, which represents either Levels 1/2/3 or Small, Medium/Large, Large/Very Large, depending on the job. In the Employee List in Compensation Management, Level 1/Small Org, Level 2/Medium Org, and Level 3/Large Org columns may be displayed based on your subscription level.

 

See Definition of Levels.  

 

For additional definitions of terms, please see the Glossary of Compensation and Benefits Terms.

 

To Change Percentiles or Mean/Median in Total Compensation

1.From Total Compensation, click on the Percentiles field above the table (the default display is Mean).

2.Select either the mean, median, 10th, 25th, 75th, or 90th percentile.

3.All of the pay elements for each job reflect the new setting.