Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1419260%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419260%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ENeed%20to%20calculate%20percentile%20for%20a%20calculating%2095th%20Percentile%20Limit%20(6.5mm)%20for%20a%20set%20of%20measurements.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%26nbsp%3BPERCENTILE.EXC%20formula%20is%20correct%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1419260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428870%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428870%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F680525%22%20target%3D%22_blank%22%3E%40Saeed2122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20PERCENTILE.EXC%20function%20returns%20the%20k-th%20percentile%20of%20values%20in%20a%20range%2C%20where%20k%20is%20in%20the%20range%200..1%2C%20exclusive.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fpercentile-exc-function-bbaa7204-e9e1-4010-85bf-c31dc5dce4ba%3Fns%3Dexcel%26amp%3Bversion%3D19%26amp%3Bsyslcid%3D1033%26amp%3Builcid%3D1033%26amp%3Bappver%3Dzxl190%26amp%3Bhelpid%3Dxlmain11.chm60549%26amp%3Bui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fpercentile-exc-function-bbaa7204-e9e1-4010-85bf-c31dc5dce4ba%3Fns%3Dexcel%26amp%3Bversion%3D19%26amp%3Bsyslcid%3D1033%26amp%3Builcid%3D1033%26amp%3Bappver%3Dzxl190%26amp%3Bhelpid%3Dxlmain11.chm60549%26amp%3Bui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

Need to calculate percentile for a calculating 95th Percentile Limit (6.5mm) for a set of measurements.

 

Is PERCENTILE.EXC formula is correct? 

1 Reply

@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...