Returns the value at a given percentile of a dataset, exclusive of 0 and 1..
81% OFF online library of tutorials for mastering Google Sheets
81% OFF online library of tutorials for mastering Google Sheets
One time purchase $199
Description
How To Use in Sheets
PERCENTILE.EXC(data, percentile)
External Links
This video shows you PERCENTILE.INC vs PERCENTILE.EXC Statistical Function with Example in MS Excel 2016.
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.