Question

How do I calculate the mean, median and mode, excluding the maximum value in Excel?

Answer 1

Suppose data values are in A1: A20

To get the maximum value in A column, we write " = MAX(A1:A20) "

Once we get the maximum value for A column, we delete the value of maximum value from the column, then to find mean, median and mode

To find mean, command " = AVERAGE(A1 : A19) "

To find median, command " = MEDIAN(A1 : A19) "

To find mode, command " = MODE(A1 : A19) "