- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
-
Functions M to Q
- MAKEARRAY
- MAP
- MATCH
- MAX
- MAXA
- MAXIFS
- MDETERM
- MDURATION
- MEDIAN
- MID
- MIDB
- MIN
- MINA
- MINIFS
- MINUTE
- MINVERSE
- MIRR
- MMULT
- MOD
- MODE
- MODE.MULT
- MODE.SNGL
- MONTH
- MONTHSPARKLINE
- MROUND
- MULTINOMIAL
- MUNIT
- N
- NA
- NEGBINOM.DIST
- NEGBINOMDIST
- NETWORKDAYS
- NETWORKDAYS.INTL
- NOMINAL
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NOT
- NOW
- NPER
- NPV
- NUMBERVALUE
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OFFSET
- OR
- PARETOSPARKLINE
- PDURATION
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- PI
- PIESPARKLINE
- PMT
- POISSON
- POISSON.DIST
- POWER
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- PRODUCT
- PROPER
- PV
- QUARTILE
- QUARTILE.EXC
- QUARTILE.INC
- QUOTIENT
- Functions R to S
- Functions T to Z
PERCENTILE.INC
This function returns the _k_th percentile of values in a range where k is between 0..1, inclusive.
Syntax
PERCENTILE.INC(array,k)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| array | Array of values representing the data |
| k | Value representing the percentile value between 0 and 1 |
Remarks
This function returns the #NUM! error value if the array is empty. If k is nonnumeric, #VALUE! is returned. If k < 0 or > 1, #NUM! is returned. The function interpolates to determine the value at the _k_th percentile if k is not a multiple of 1/(n-1).
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
PERCENTILE.INC(A1:A12,0.95)
PERCENTILE.INC(R1C1:R1C45,0.866)
PERCENTILE.INC({5,15,25,50,65},0.45) gives the result 23
Version Available
This function is available in Spread for Windows Forms 11.0 or later.