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.