But quartile formula helps us in understanding all these elements. Also, there are other statistical tools which tell us about the range of the data set, the center of the data set, etc. A quartile is an extended version of that and by dividing the data set in four parts, it deals with the spread of values above and below the mean. The median divides the data set in exactly two equal halves but it does not tell us anything about the spread of the data on either side. To get a better understanding of quartiles, we need to understand the median in a better way. Upper Quartile (Q3)= 48 / 4 = 12 th data point.Middle Quartile (Q2)= 32 / 4 = 8 th data point.Lower Quartile (Q1)= 16 / 4 = 4 th data point.Calculate the Quartile.Īrrange the shoe size in ascending order. You have collected a sample of 15 athletes from different sports. You have collected the data of the shoe sizes these athletes wear so that in future you produce more of that size to meet demand. Suppose that you are a manufacturer of running shoes and a well-known brand amongst the athletes who run a marathon, play sports, etc. Let’s see another example of how companies and businesses can use this tool to make an informed decision on which product to produce. Value 67 divides the data set in such a way that the highest 25% are below it and the lowest 75% are above it.Value 43 divides the data set in two equal parts.Value 29 divides the data set in such a way that the lowest 25% are above it and the highest 75% are below it.If you see the data set, the median of this set is: (n+1)/2 = 20/2 = 10 th value i.e. Interquartile Range is calculated using the formula given below Upper Quartile (Q3)= 60 / 4 = 15 th data point.Middle Quartile (Q2) = 40 / 4 = 10 th data point.Lower Quartile (Q1) = 20 / 4 = 5 th data point.Quartile is calculated using below given formula Calculate the Quartile for data set A.įirst of all, you have to arrange this ascending order i.e. Let’s say we have a data sets A which contains 19 data points. You can download this Quartile Formula Excel Template here – Quartile Formula Excel Template Quartile Formula – Example #1

Rumus median