Microsoft Excel Functions & Formulas

Use the MEDIAN function to calculate the

median sales

In this example the average and median sales for a month have to

be determined. Use the data shown in Figure 5-17 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.

4

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 ...