Microsoft Office Tutorials and References
In Depth Information
QUARTILE
QUARTILE
QUARTILE returns the quartile of a data set.
=QUARTILE(array,quart)
The QUARTILE function is used frequently to divide data into four equal parts and return the
average of the quartile you specify. In Figure 11.39, the QUARTILE function is being used to
locate the top twenty-fifth percentile of price-earnings ratios for 12 companies.
Is the data set of numeric values for which you want the quartile value.
ARRAY
Indicates the value you want to return. (See Table 11.2.)
QUART
Table 11.2
Quart Value Results
Quart Value
Result
0
Minimum value
1
First quartile (25th percentile)
2
Second quartile (50th percentile)
3
Third quartile (75th percentile)
4
Maximum value
Figure 11.39
The MEDIAN function
returns the same result
as QUARTILE when
Quart is 2.
Search JabSto ::




Custom Search