.

QUARTILE Function Dictionary

Function Dictionary Function Examples Function Categories

QUARTILE              
 
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.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download