# how to find the median of two numbers

Share onContents:Definition and Median Formula.Calculation for an odd set of numbers.Calculation for an even set of numbers.Average vs. Median.Calculation for a Grouped Frequency D

Share on

Contents:

1. Definition and Median Formula.
2. Calculation for an odd set of numbers.
3. Calculation for an even set of numbers.
4. Average vs. Median.
5. Calculation for a Grouped Frequency Distribution.
6. Excel Instructions
7. Median in Minitab (video)

Watch the video to see how to calculate the median:
Mean Median Mode

## What is the Median?

The median tells you where the middle of a data set is. Its used for many real-life situations, like Bankruptcy law, where you can only claim bankruptcy if you are below the median income in your state.

The median formula is {(n + 1) ÷ 2}th, where n is the number of items in the set and th just means the (n)th number.

To find the median, first order the numbers from smallest to largest. Then find the middle number. For example, the middle for this set of numbers is 5, because 5 is right in the middle:
1, 2, 3, 5, 6, 7, 9.
You get the same result with the formula. There are 7 numbers in the set, so n = 7:

• {(7 + 1) ÷ 2}th
• = {(8) ÷ 2}th
• = {4}th

The 4th number in 1, 2, 3, 5, 6, 7, 9 is 5.

A caution with using the median formula: The steps differ slightly depending on whether you have an even or odd amount of numbers in your data set.

### Find the median for an odd set of numbers

Example question: Find the median for the following data set:
102, 56, 34, 99, 89, 101, 10.

Step 1: Sort your data from the smallest number to the highest number. For this example data set, the order is:
10, 34, 56, 89, 99, 101, 102.

Step 2: Find the number in the middle (where there are an equal number of data points above and below the number):
10, 34, 56, 89, 99, 101, 102.
The median is 89.

Tip: If you have a large data set, divide the number in the set by 2. That tells you how many numbers should be above and how many numbers should be below. For example, 101/2 = 55.5. Ignore the decimal; 55 numbers should be above and 55 below.

### Find the median for an even set of numbers

Example question: Find the median for the following data set:
102, 56, 34, 99, 89, 101, 10, 54.

Step 1: Place the data in ascending order (smallest to highest).
10, 34, 54, 56, 89, 99, 101, 102.

Step 2: Find the TWO numbers in the middle (where there are an equal number of data points above and below the two middle numbers).
10, 34, 54, 56, 89, 99, 101, 102

Step 3: Add the two middle numbers and then divide by two, to get the average:

• 56 + 89 = 145
• 145 / 2 = 72.5.

The median is 72.5.
Tip: For large data sets, divide the number of items by 2, then subtract 1 to find the number that should be above and the number that should be below. For example, 100/2 = 50. 50  1 = 49. The middle two numbers will have 49 items above and 49 below.
Thats it!

## Average vs. Median

The median is very useful for describing things like salaries, where large figures can throw off the mean. The median salary in the U.S. as of 2012 was \$51,017. If an average was used, those American billionaires could skew that figure upwards.

Lets say you wanted to work for a small law firm that paid an average salary of over \$73,000 to its 11 employees. You might think theres a good chance youll land a great paying job. But take a closer look at how the average is calculated for those eleven employees:EmployeeSalarySamuel\$28,000Candice\$17,400Thomas\$22,000Ted\$300,000Carly\$300,000Shawanna\$20,500Chan\$18,500Janine\$27,000Barbara\$21,000Anna\$29,000Jim\$20,000

Average (Mean) =
(\$28,000 + \$17,400 + \$22,000 + \$300,000 + \$300,000 + \$20,500 + \$18,500 + \$27,000 + \$21,000 + \$29,000 + \$20,000) / 11 = \$73,000

The two partners in the firmTed and Carly, have increased the average way beyond most of the salaries paid in the firm.

See how the average can be misleading?

A better way to describe income is to figure out the median  or the middle wage. If you took that same list of incomes and found the median, you would get a more realistic representation of income. The median is the middle number, so if you placed all of the incomes in a list (from smallest to largest) you would get:

\$17,400, \$18,500, \$20,000, \$20,500 \$21,000, \$22,000, \$27,000, \$28,000, \$29,000, \$300,000, \$300,000

Its a more accurate representation of what people are actually being paid.

## Calculation for a Grouped Frequency Distribution

An easy way to ballpark the median(MD) for a grouped frequency distribution is to use the midpoint of the interval. If you need something more precise, use the formula:
MD = lower value + (B ÷ D) x C.

Step 1: Use (n + 1) / 2 to find out which interval has the MD. For example, if you have 11 intervals, then the MD is in the sixth interval: (11 + 1) / 2 = 12 / 2 = 6. This interval is called the MD group.

Step 2: Calculate A: the cumulative percentage for the interval immediately before the median group.

Step 3: Calculate B: subtract your step 2 value from 50%. For example, if the cumulative percentage is 45%, then B is 50%  45% = 65%.

Step 4: Find C: the range (how many numbers are in the interval).

Step 5: Find D: the percentage for the median interval.

Step 7: Find the median: Median = lower value + (B ÷ D) x C.

Thats it!

## Find the median in Excel

Contents:

1. Excel 2013.
2. Excel 2007-2010.

## Excel 2013

Watch the video or read the steps below:
How to Find a Median in Excel 2013

There are two ways to find the median in Excel  with a function or with the Data Analysis tool. The Data Analysis Toolpak has several advantages over just entering formulas. First, it gives you access to many functions that arent available in the standard package of Excel (like histograms). Second, you wont have to remember formulas, as the Toolpak is a Click and Go interface.

### MEDIAN function

Step 1: Type =MEDIAN(A1:A12) into a blank cell where A1:A12 is the location of your data. For example, if youve typed your data into D1 to D12, change to =MEDIAN(D1:D12).
Step 2: Press Enter.

### Data Analysis Toolpak

Step 1: Click the Data tab and then click Data Analysis.
Step 2: Click Descriptive Statistics and then click OK.
Step 3: Click the Input Range box and then type the location for your data. For example, if you typed your data into cells A1 to A10, type A1:A10 into that box
Step 4: Click the radio button for Rows or Columns, depending on how your data is laid out.
Step 5: Click the Labels in first row box if your data has column headers.
Step 6: Click the Descriptive Statistics check box.
Step 7: Select a location for your output. For example, click the New Worksheet radio button.
Step 8: Click OK.

## Median in Excel 2007-2010.Median in Excel 2007

Example question: Find the median for the following set: 123, 563, 567, 22, 498, 593, 947, 4, 46, 876, 223, 567.1 ,222.22.

Step 1: Enter your data into a single column. For this example, type 123 into cell A1, press Enter and continue entering the numbers down the column from A1 to A13.

Step 2: Click an empty cell.

Step 3: Click the Formulas tab and then click Insert Function.

Step 4: Type Median into the Search for a function text box and then click Go. Median should be highlighted in the results list. Click OK.

Step 5: Type the cell range into the Number1 cell. In most cases, Excel will automatically populate this with your list already. If it doesnt, type A1:A13 into the Number1 box, where A1:A13 is the actual location of your data.

Step 6: Click OK. The answer will be displayed in the cell you selected in Step 2. For this sample, the median is 498.

To Place Your Data in Order:

1. Click the letter at the top of the column where you want ordered numbers. For this example, click A.
2. Click the arrows to the right of the drop down lists to change your options. For example, you might choose Order as Smallest to Largest or Largest to Smallest.
3. Click OK.

## Median in Minitab (video)

This video shows you how to find the median in Minitab in under a minute:
How to find the median in Minitab