Please see me my other Excel articles.
As illustrated in my Median article (link) – understanding the median on a data set provides a helpful concept to know the value within the middle of all values of the data set.
This article with illustrate median values within various divisions of the data set, or “inter” median values of the data set.
First, I will begin with a data set showing disease diagnoses attached to various age groups.
The QUARTILE() function allows you to divide a data set into four possible quartiles and return its median.
First, I’ll use the QUARTILE() function to display the data set’s minimum value.
Next, I’ll use the function to display the 25th quartile (or lower 25% of the data set) and its median.
As you see, the median for the 25th quartile is 30. This is the same value for the media of the lower half of the data set.
Next, I’ll use the same function to display the median for the 50th (or 50%) quartile.
Now that I’ve displays medians for the lower half and the exact middle, I’ll use the function to display the median the 75th quartile (or upper 75% of the data set).
As you see, the median for the 75th quartile is 66. This is the same value for the media of the lower half of the data set.
Finally, I’ll use the function to display the highest value.