Editing Percentile (section)

====Third variant, ''C'' = 0====

(The primary variant recommended by [[National Institute of Standards and Technology|NIST]].<ref name="nist" /> Adopted by Microsoft Excel since 2010 by means of PERCENTIL.EXC function. However, as the "EXC" suffix indicates, the Excel version ''excludes'' both endpoints of the range of ''p'', i.e., <math>p\in(0,1)</math>, whereas the "INC" version, the second variant, does not; in fact, any number smaller than <math>\frac 1 {N+1}</math> is also excluded and would cause an error.)

: <math>x = f(p,N) = \begin{cases}
1\text{, }p\in\left[0,\frac{1}{N+1}\right] \\
p(N+1)\text{, }p\in\left(\frac{1}{N+1},\frac{N}{N+1}\right) \\
N\text{, }p\in\left[\frac{N}{N+1},1\right]
\end{cases}.</math>
The inverse is restricted to a narrower region:
: <math>p = \frac{x}{N+1}\text{, }x\in(0,N).</math>