Which function is best suited to determine a student's test score percentile based on all class scores?
A)RANK.AVG
B)PERCENTRANK.EXC
C)AVERAGE
D)AVERAGEIFS

Question

Quizplus · Accepted Answer

PERCENTRANK.EXC is the function best suited for determining a student's test score percentile based on all class scores. It calculates the rank of a value within a data set as a percentage of the total number of values in the data set, excluding the value itself. This is exactly what is needed to determine a student's score percentile compared to the rest of the class. RANK.AVG would give the raw rank of the student's score, but not the percentile. AVERAGE and AVERAGEIFS have no relevance in determining percentiles.

Which Function Is Best Suited to Determine a Student's Test