Formula To Find Upper Quartile. Interquartile range q3 q1. 1 2 5 6 7 9 12 15 18 19 27.
Inc stands for inclusive which will give you results that include 0 100. The formula for calculating the upper quartile is q3 n 1. This means the 4 5th term is q3.
First lets arrange of the values in an ascending order.
4 select the cells containing your data. For example if you have 10 numbers in your data set you would solve q3 10 1 then solve x 11 which would give you 8. This means the 4 5th term is q3. Q1 2 75 term.
