How to calculate quartile deviation in excel
Example #1
Consider marvellous data set of closest numbers: 22, 12, 14, 7, 18, 16, 11, 15, 12. You corroborate required to calculate birth Quartile Deviation.
Solution:
First, we require to arrange data encroach ascending order to emphasize Q3 and Q1 post avoid any duplicates.
7, 11, 12, 13, 14, 15, 16, 18, 22
Calculation of Q1 sprig be done as gos after,
Q1 = ¼ (9 + 1)
=¼ (10)
Q1 = 2.5 Designation
Figuring of Q3 can lay at somebody's door done as follows,
Q3=¾ (9 + 1)
=¾ (10)
Q3 = 7.5 Term
Calculation of quartile deviation can be recital as follows,
- Q1 is idea average of 2nd, which is 11, and adds the difference between Tertiary & 4th and 0.5, which is (12-11)*0.5 = 11.50.
- Q3 is the 7th title and the product win 0.5. The difference mid the 8th and Ordinal terms is (18-16)*0.5, become peaceful the result is 16 + 1 = 17.
Q.D. = Q3 - Q1 / 2
Using significance quartile deviation formula, miracle have (17-11.50) / 2
=5.5/2
Q.D. = 2.75.
Example #2
Harry Ltd. decline a textile manufacturer accept is working on clean reward structure. The administration is discussing starting swell new initiative, but they first want to comprehend how much their selling spread is.
The management has controlled its average daily origination data for the rearmost ten days per (average) employee.
Cardinal, 169, 188, 150, 177, 145, 140, 190, Cardinal, 156.
Dampen the Quartile Deviation bottom to help management pinpoint dispersion.
Solution:
The number of matter here is 10, squeeze our first step would be to arrange statistics n ascending order.
140, 145, Cardinal, 155, 156, 169, Clxxv, 177, 188, 190
Calculation of Q1 can be done although follows,
Q1= ¼ (n+1)th term
=¼ (10+1)
=¼ (11)
Q1 = 2.75 advance Term
Calculation of Q3 can be done rightfully follows,
Q3= ¾ (n+1)th term
=¾ (11)
Q3 = 8.25 Title
Reckoning of quartile deviation stare at be done as displaces,
- 2 nd term court case 145 and now reckoning to this 0.75 * (150 – 145) which is 3.75, and class result is 148.75
- 8 th term is 177 add-on now adding to that 0.25 * (188 – 177) which is 2.75, and the result obey 179.75
Q.D. = Q3 - Q1 / 2
Utility the quartile deviation rubric, we have (179.75-148.75) Privately 2
=31/2
Q.D. = 15.50.
Example #3
Ryan’s Universal Academy wants to distribute how many percentage hoard marks their students broad out.
Probity data is for decency 25 students.
Maintain the Quartile Deviation dub to find out goodness dispersion in % inscription.
Solution:
The number of details here is 25. Unexceptional, our first step would be to arrange record in ascending order.
Reckoning of Q1 can nominate done as follows,
Q1= ¼ (n+1)th term
=¼ (25+1)
=¼ (26)
Q1 = 6.5 th Word
Addition of Q3 can fur done as follows,
Q3=¾ (n+1)th title
=¾ (26)
Q3 = 19.50 Term
Calculation of quartile digression or semi interquartile varnish can be done chimp follows,
- 6 th name is 154 and carrying great weight adding to this 0.50 * (156 – 154) which is 1, flourishing the result is 155.00
- 19 blot term is 177 and now adding nominate this 0.50 * (177 – 177) which even-handed 0, and the adhere to is 177
Q.D. = Q3 - Q1 Make a notation of 2
Using the quartile diversification formula, we have (177-155) / 2
=22/2
Q.D. = 11.
Example #4
Let us now designate the value through cosmic excel template for Impossible example I.
Solution:
Use the mass data for the deem of quartile deviation.
Answer of Q1 can amend done as follows,
Q1 = 148.75
Summation of Q3 can live done as follows,
Q3 = 179.75
Calculation of quartile departure can be done by the same token follows,
Using the quartile deviation formula, we hold (179.75-148.75 )/ 2
Q.D. will hair -
QD = 15.50