Microsoft Office Tutorials and References
In Depth Information
Analyzing Data with Percentiles and Bins
2, 3, or 4 when using QUARTILE.INC; or 1, 2, or 3 when using QUARTILE.EXC.
QUARTILE.EXC is used when the minimum and maximum values are to be
excluded, therefore, that version of the function does not take 0 0r 4 as the
second argument:
Formula
Result
Minimum value in the data
=QUARTILE.INC(A4:A503,0)
=QUARTILE.INC(A4:A503,1)
Value at the 25th percentile
=QUARTILE.INC(A4:A503,2)
Value at the 50th percentile
=QUARTILE.INC(A4:A503,3)
Value at the 75th percentile
=QUARTILE.INC(A4:A503,4)
Maximum value in the data
Figure 9-14:
Finding out
values at
quarter
percentiles.
QUARTILE.INC (or QUARTILE.EXC) works on ordered data, but you don’t
have to do the sorting; the function takes care of that. In Figure 9-14, the
quartiles have been calculated. The minimum and maximum values have
been returned by using a 0 and a 4, respectively, as the second argument.
Here’s how to use the QUARTILE function:
1. Enter a list of numerical values.
2.Positionthecursorinthecellwhereyouwantaparticularquartile
to appear.
3. Enter =QUARTILE.INC( to start the function.
4. Drag the pointer over the list, or enter the address of the range.
5. Enter a comma ( ,).
6. Enter a value between 0 and 4 for the second argument.
7. Enter a ) and press the Enter key.
Search JabSto ::




Custom Search