Statistical functions normsdist, normsinv, percentile, percentrank, permut
Excel Function NORMSDIST
The NORMSDIST() function is used to calculate the standard normal cumulative distribution function.
By Normal, it means, the mean is 0 and standard deviation is 1.
| Value | NORMSDIST() | Formula |
| 2 | 0.977249868051821 | =NORMSDIST(L5) |
| 45 | 1 | =NORMSDIST(L6) |
| 3 | 0.99865010196837 | =NORMSDIST(L7) |
| 1 | 0.841344746068543 | =NORMSDIST(L8) |
Excel Function NORMSINV
The NORMSINV() function is used to calculate the inverse of the standard normal cumulative distribution.
This function takes single argument which is the probability.
The syntax is as follows:
NORMSINV(probability)
| Probability | NORMSINV() | Formula |
| 0.2 | -0.841621233572915 | =NORMSINV(L14) |
| 0.4 | -0.2533471031358 | =NORMSINV(L15) |
| 0.5 | 0 | =NORMSINV(L16) |
| 0.9 | 1.2815515655446 | =NORMSINV(L17) |
Excel Function PERCENTILE
The PERCENTILE() function returns the kthpercentile for a given set of values at a specified k.
The kth percentile is nothing but the value below which the k% of the data values fall.
The syntax is as follows:
PERCENTILE(num_array,k)
| numbers | k | Formula | Formula |
| 2 | 1 | 7 | =PERCENTILE(L$26:L$29,M26) |
| 3 | 0.9 | 6.7 | =PERCENTILE(L$26:L$29,M27) |
| 6 | 0.2 | 2.6 | =PERCENTILE(L$26:L$29,M28) |
| 7 | 0.5 | 4.5 | =PERCENTILE(L$26:L$29,M29) |
Excel Function PERCENTRANK
The PERCENTRANK() function is used to calculate the rank of a value in a set of values as a percentage.
The syntax of the function is as follows:
PERCENTRANK(value_array,x,[no. of digits])
| numbers | x | PERCENTRANK() |
| 1 | 1 | 0 |
| 5 | 8 | Error 2042 |
| 8 | 9 | Error 2042 |
| 11 | 11 | Error 2042 |
=PERCENTRANK(L41:L44,M41)
Excel Function PERMUT
The PERMUT() function is used to calculate the number of permutations of a given number of entities.
The syntax is as follows:
PERMUT(number,num_permutation)
| PERMUT() | Formula |
| 6 | =PERMUT(3,2) |
| 2 | =PERMUT(2,1) |
| 3628800 | =PERMUT(10,9) |
| 1 | =PERMUT(0.4,0.1) |