Q1 is the median of the group on the left, and Q3 is the median of the group on the right.

Then divide the numbers into 2 groups, each containing an equal number of values: The interquartile range is the difference between the third and first quartiles.įirst reorder the numbers in ascending order: The median of the upper half falls between two values. The median of the lower half falls between two values. Is the overall median, leaving as the lower half of the data and as the upper half of the data. Solution:įirst, we need to put the data in order from smallest to largest. Now that we have solved a few examples, let's use this knowledge to solve the given problem. In order to better illustrate these values, their positions in a box plot have been labeled in the provided image. This value equals the IQR.įinally, we will find the IQR of the even data set. Last, we need to calculate the difference of the upper and lower medians by subtracting the lower median from the upper median. The median of the upper portion is eight. Afterwards, we will calculate the medians of both the upper and lower portions. These values are not omitted and become the largest value of the lower data set and the lowest values of the upper data set, respectively. If the data set has an even number of values, we will use the two values used to calculate the original median to divide the data set.

Afterwards, we will find the individual medians for the upper and lower portions of the data. If the data set has an odd number of values, we will omit the median or centermost value of the set. Once we have found the median of the entire set, we can find the medians of the upper and lower portions of the data.

The median of the even valued set is four. Cross out values until you find the two centermost points and then calculate the average the two values.įind the average of the two centermost values. Now, let's find the mean of the data set with an even number of values. The median of the odd valued data set is four. Cross out values until you find the centermost point We will calculate this average by adding the two numbers together and then dividing that number by two.įirst, we will find the median of a set with an odd number of values. On the other hand, if the data set has an even number of values, then we will need to take the arithmetic average of the two centermost values. If the data set has an odd number of data points, then the mean is the centermost number. Now, let's perform this task with another example data set that is comprised of an even number of values. Let's sort an example data set with an odd number of values into ascending order. Likewise, in order to calculate the median, we need to arrange the numbers in ascending order (i.e. In order to calculate the IQR, we need to begin by ordering the values of the data set from the least to the greatest. The IQR is the difference between the upper and lower medians.Calculate the median of both the lower and upper half of the data.We can find the interquartile range or IQR in four simple steps: Explanation: How do you find the interquartile range?

Interquartile range excel