Question

Which statistical function in a spreadsheet helps you to see how far each number varies, on average, from the average value of the list?

Answer 1

RANK.AVG function

This function in Excel helps return the statistical rank of a specific value within a list of numbers. The statistical rank is calculated by arranging the number usually, in a descending way and then assigning a position to each value in a list.