In cell F2, which formula returns the averaged rank of the value in C4 among the values in C2:C13?

In cell F2, which formula returns the averaged rank of the value in C4 among the values in C2:C13?

• A. =RANK.AVG(C4, C2:C13)
• B. =RANK.AVG(C2, C4:C13)
• C. =AVERAGE.RANK(C4, C2:C13)
• D. =RANK.EQ(C4, C2:C13)

Answer: (A)

To get the averaged rank of a specific value within a list, use the RANK.AVG function. It ranks the number within the given range and, if there are ties, returns the average of the tied positions. For the value in C4 among the values in C2:C13, the correct formula is =RANK.AVG(C4, C2:C13). It uses C4 as the value to rank and C2:C13 as the data set, giving the average rank in case of ties. The other options either rank the wrong cell, use the wrong function, or return a non-averaged rank when ties occur.

To get the averaged rank of a specific value within a list, use the RANK.AVG function. It ranks the number within the given range and, if there are ties, returns the average of the tied positions. For the value in C4 among the values in C2:C13, the correct formula is =RANK.AVG(C4, C2:C13). It uses C4 as the value to rank and C2:C13 as the data set, giving the average rank in case of ties. The other options either rank the wrong cell, use the wrong function, or return a non-averaged rank when ties occur.