The median is the middle number in a sorted ascending or descending list. It can be more descriptive of the dataset than the average. It’s quite different from the mean.

Now, to calculate the median click inside any cell and use the formula as simple as this: =MEDIAN (D2:D8) Instantly, the median value corresponding to the data will be visible in the cell.

Learn about and revise how to find the mean, median and mode averages from data with this BBC Bitesize GCSE Maths OCR study guide.