Microsoft Office Tutorials and References
In Depth Information
Using PERCENTILE.INC to Calculate Percentile
Figure 14.8.
Figure 14.8. The
The QUARTILE.INC
QUARTILE.INC function can break up a data set into four
function can break up a data set into four
equal pieces.
equal pieces.
After the QUARTILE.INC functions build the table in B20:C23, the VLOOKUP
function returns the text in C2:C17. The formula in cell C2 is
=VLOOKUP(B2,$B$20:$D$23,3,TRUE).
Using
Using PERCENTILE.INC
to Calculate Percentile
The QUARTILE.INC function is fine if you are trying to find every record that
is in the top 25% of a range. Sometimes, however, you need to find some other
percentile. For example, all employees ranked above the 81st percentile might
be eligible for a bonus this year. You can use the PERCENTILE.INC function
to determine the threshold for any percentile.
PERCENTILE.INC to Calculate Percentile
Search JabSto ::




Custom Search