The MEDIAN function identifies the middle number in a range of cells, which is useful for analyzing data without being skewed by outliers.
AI に任せるSelect the cell
Click on the empty cell where you want the median result to appear.
Enter the formula
Type '=MEDIAN(' into the cell.
範囲を選ぶ
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.