Excel Median Function is one of the central tendency functions, like AVERAGE and MODE. See how these functions work differently, and see how the MEDIAN function is used to create a Box Plot chart
MEDIAN is one of the central tendency functions, along with AVERAGE and MODE.
Below, you can see a couple of very simple examples of measuring a small set of numbers.
In the next example, the numbers are NOT symmetrically distributed, as you can see in the COUNT chart.
The second chart shows that the AVERAGE, MEDIAN and MODE are different
Read more about MEDIAN on the Microsoft site.
I also enjoyed this article that compares the median and mean (average) functions.
If you would like to test the data and formulas from the above examples, try this interactive Excel workbook, shown below.
There are two worksheets with number sets – one is symmetrically distributed, and the other is not.
To get the score counts, I used the FREQUENCY function.
To see the steps for creating a simple box plot chart, using MEDIAN and other functions, watch this short video. The written instructions are on the Excel Box Plot Chart page.
Note: To see the video transcript, go to the Box Plot Chart Video page.
Download the completed Excel workbook that was used in this video -- Simple Box Plot Chart. The zipped file is in xlsx format, and does not contain macros.
Last updated: March 16, 2021 4:08 PM
Contextures RSS Feed