Identify the statistical function used if the rank value returned for duplicate values was 8.5?
A)RANK.AVG
B)RANK.EQ
C)RANK.SP
D)RANK

Question

Quizplus · Accepted Answer

RANK.AVG is used when you want to assign the average rank to each duplicate value in a list of numbers. If the rank value returned for duplicate values was 8.5, it means the average rank was calculated for those duplicates, which is what RANK.AVG does.

Identify the Statistical Function Used If the Rank Value Returned