• The value of the middle number
• Or the mean of the two middle numbers when there are an even number of data
• To calculate: order the numbers from smallest to largest then find the middle number or average of two middle numbers (for even sized data sets)

Finding the median For an Odd numbers of Data (ExerCise)

Finding the median for AN EVEN number of Data

Example 2.2

Find the median of the following numbers: 25, 19, 24, 23, 28, 21

Step 1: Order the data: 19, 21, 23, 24, 25, 28

Step 2: Find the middle values: 19, 21, 23, 24, 25, 28

Step 3: Average the middle values: (23 + 24)/ 2 = 23.5

Conclusion: The middle value (median) for the above data set is 23.5.

Finding the median using Excel (VIDEO)

Example 2.3.1

Find the median using Excel.

• We use the =median() call in Excel to calculate the median.
• See the video below.
• Click here to download the solution shown in the video below.

Comparing the Mean and Median (VIDEO)

Example 2.3.2

• The median can be greatly affected by outliers (extreme values)
• The median is a better reflection of the middle value in data set because it does not get affected by extreme values
• See the video below for an example.
• Click here to download the Excel file shown in the video below.

Key Takeaways (Exercise)

Your Own Notes

• Are there any notes you want to take from this section? Is there anything you’d like to copy and paste below?
• These notes are for you only (they will not be stored anywhere)
• Make sure to download them at the end to use as a reference