Work Out Upper Quartile. If the size of the data set is even the median is the average of the middle 2 values in the data set. 5 7 2 6 Middle quartile.
In the example you have a group of runners w. 3 rd quartile or the upper quartile separate the highest 25 of data from the lowest 75. Add those 2.
Use the QUARTILE function to get the quartile for a given set of data.
Quartiles divide a set of numbers into four equal parts. Use the QUARTILE function to get the quartile for a given set of data. The median divides the data into a lower half and an upper half. If the size of the data set is odd do not include the median when finding the first and third quartiles.
