Microsoft Office Tutorials and References

In Depth Information

**Analyzing Data with Percentiles and Bins**

The difference between RANK.EQ and RANK.AVG is that if more than one

value is at the same rank, then RANK.EQ will use the larger value, whereas

RANK.AVG will use the average of the values.

Figure 9-16 displays a list of employees and the bonuses they earned. Say

youâ€™re the employee who earned $4,800. You want to know where you rank

in the range of bonus payouts. Cell F4 contains a formula with the RANK.

EQ function: =RANK.EQ(C9,C3:C20). The function returns an answer of 4.

Note that the function was entered without the third argument. This tells the

function to sort the distribution descending in determining where the value

is positioned. This makes sense for determining how close to the
top
of the

range a value is.

Figure 9-16:

Determining

the rank

of a value.

Follow these steps to use the RANK function:

1. Enter a list of numerical values.

2. Position the cursor in the cell where you want the result to appear.

3. Enter
=RANK.EQ(
to start the function.

4. Click the cell that has the value you want to find the rank for, or enter

its address.

You can also just enter the actual value.

5. Enter a comma (
,).

6. Drag the pointer over the list of values, or enter the address of the

range.