May 26 2020 06:18 PM
Hi,
Need to calculate percentile for a calculating 95th Percentile Limit (6.5mm) for a set of measurements.
Is PERCENTILE.EXC formula is correct?
May 30 2020 11:05 AM
@Saeed2122
The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
https://support.microsoft.com/en-us/office/percentile-exc-function-bbaa7204-e9e1-4010-85bf-c31dc5dce...