Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present?
A)RANK.EQ
B)RANK.AVG
C)RANK
D)PERCENTILE

Question

Quizplus · Accepted Answer

The RANK.AVG function will use the average value to determine the rank of a number within a list if duplicate values are present. RANK.EQ will only return the rank of the first occurrence of a number, while RANK will return the same rank for each of the duplicate numbers. PERCENTILE is not relevant to determining the rank of a number within a list.

Which of the Following Functions Will Use Average Values to Determine