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.
No comments:
Post a Comment