Use the MEDIAN function to calculate the median sales - Basic Statistical Function - Microsoft Excel Tutorials

Use the MEDIAN function to calculate the median sales using Microsoft Excel

In this example the average and median sales for a month have to be determined. Use the data shown in Figure and calculate the average sales in cell E2. To calculate the median of the sales, use the MEDIAN function. The median is a value in the middle of a set of values; that is, half the values are above the median and half the values are below.

MEDIAN(number1, number2, ...)

number1, number2,… : From 1 to 30 numbers for which you want to find the median.

To calculate the median sales:

1. In cells A2:A13 type the month.
2. In cells B2:B13 type the monthly sales.
3. Select cells E1 and type the following formula: =MEDIAN(B2:B13).
4. Press <-Enter->.

Use the MEDIAN function to calculate the median sales

Note: You can find the average, as shown in cell E2, by using the formula =AVERAGE(B2:B13).