QUARTILE Function (Functions in Excel)
Values | Quarter No. | Quartile | ||
1 | 0 | 1 | =QUARTILE(C4:C8,E4) | |
25 | 1 | 25 | =QUARTILE(C4:C8,E5) | |
50 | 2 | 50 | =QUARTILE(C4:C8,E6) | |
75 | 3 | 75 | =QUARTILE(C4:C8,E7) | |
100 | 4 | 100 | =QUARTILE(C4:C8,E8) |
Values | Quarter No. | Quartile | |||||
817 | 104 | 640 | 767 | 0 | 104 | =QUARTILE(C12:F16,H12) | |
748 | 756 | 369 | 703 | 1 | 285.75 | =QUARTILE(C12:F16,H13) | |
372 | 993 | 294 | 261 | 2 | 489 | =QUARTILE(C12:F16,H14) | |
487 | 384 | 185 | 491 | 3 | 750 | =QUARTILE(C12:F16,H15) | |
140 | 607 | 894 | 182 | 4 | 993 | =QUARTILE(C12:F16,H16) |
What Does It Do ? |
This function examines a group of values and then shows the values which are of the |
upper limits of the 1st, 2nd, 3rd and 4th quarters of the data. |
The Quartile of 0 (zero) is actually lowest value, which can be obtained using the =MIN() function. |
The Quartile of 4 is actually highest value, which can be obtained using the =MAX() function. |
Syntax |
=QUARTILE(RangeToBeExamined,QuartileValue) |
The QuartileValue can only be 0,1,2,3 or 4. |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment