# How to calculate the median of a data set

## How do you find a median of a data set?

**To find the median:**

- Arrange the data points from smallest to largest.
- If the number of data points is odd, the median is the middle data point in the list.
- If the number of data points is even, the median is the average of the two middle data points in the list.

## What is the fastest way to find the median?

To find the median, put all numbers into ascending order and work into the middle by crossing off numbers at each end. If there are a lot of items of data,

**add 1 to the number of items of data and then divide by 2**to find which item of data will be the median.## What is the median of the data 78 56 22 34?

Hence, the median of given data is

**54**.## How do I find the median of a data set in Excel?

Enter the following formula, without quotes, into the cell: “

**=MEDIAN(A:A)**“. Press “Enter” and the median of your set of numbers will appear in the cell.## What is the median of 10 numbers?

Arrange all 10 numbers in ascending or descending order. Since there is an even number of numbers in the list, there is no single “middle” number, so the median will be

**the mean of the two numbers in the middle (5th and 6th, when in order)**. Add the two middle numbers and divide their sum by 2. That’s the median.