QUARTILE
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.
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.
=QUARTILE(RangeToBeExamined,QuartileValue)
The QuartileValue can only be 0,1,2,3 or 4.
Formatting
No special formatting is needed.
No special formatting is needed.
