Руководство Excel

How to Calculate the Median in Excel

The MEDIAN function identifies the middle number in a range of cells, which is useful for analyzing data without being skewed by outliers.

Пошагово

1
Select the cell
Click on the empty cell where you want the median result to appear.
2
Enter the formula
Type '=MEDIAN(' into the cell.
3
Выберите диапазон
Highlight the range of cells containing your data, then type ')' and press Enter.

=MEDIAN(range)

The MEDIAN function ignores empty cells, text, and logical values within the selected range.

What is the difference between average and median?

The average is the sum of values divided by the count, while the median is the exact middle value of the sorted data.