Upper Quartile Formula. Interquartile Range Q3 Q1. The upper quartile is the value which is three quarters of the way into our data.
The upper quartile is 25 of the 3 n 2th data point plus 75 of the 3 n 3th data point. The upper quartile or third quartile is the middle value of the upper half. Quartile 1 Q1 4 Quartile 2 Q2 which is also the Median 5 Quartile 3 Q3 7 Sometimes a cut.
So firstly we put your numbers in order.
For example 5th place 8th place etc. So Upper Quartile Q3 11. 4 Select the cells containing your data. 1 2 5 6 7 9 12 15 18 19 27.