The MEDIAN function identifies the middle number in a range of cells, which is useful for analyzing data without being skewed by outliers.
Gör det med AISelect the cell
Click on the empty cell where you want the median result to appear.
Enter the formula
Type '=MEDIAN(' into the cell.
Välj området
Highlight the range of cells containing your data, then type ')' and press Enter.
=MEDIAN(range)The average is the sum of values divided by the count, while the median is the exact middle value of the sorted data.