PERCENTILE

Use PERCENTILE to identify a value that represents x% of a group of values. For example, you can use this function to grant bonuses only to employees with scorecard scores in the 60% percentile. This means that 60% of employees score below this level. PERCENTILE identifies the scorecard score that employees must have to receive a bonus.

PERCENTILE has following syntax. V1 represents the kind of values you are using, such as scores or results. K represents the percentage to use.

PERCENTILE(v1,v2,v3,k)

For example, PERCENTILE(onScorecardMeasures(score, “scorecard”),75%) inserts the value for which 75% of all scores are below.

  To use this function:

  1. Select Functions, then Statistical, and double-click PERCENTILE.

    This inserts PERCENTILE(v1,v2...,k)

  2. Place the cursor after the first bracket.

  3. Replace v1, v2...with the function that inserts the kind of values to use.

    For example, to use the scorecard’s score, insert thesScore function.

  4. Select the object whose values to use from the box that is displayed.

  5. Repeat steps 3-4 to insert all the object values to use.

  6. Replace k with the percentage to use.

    For example, PERCENTILE(onScorecardMeasures(result, “scorecard name”),%80)