Returns the inverse of the cumulative distribution function for the specified mean and standard deviation.

Syntax

NORMINV(probability,mean,standard_dev)

where

Probability |
is a probability corresponding to the normal distribution (must be > 0 and < 1). |

Mean |
is the arithmetic mean of the distribution. |

Standard_dev |
is the standard deviation of the distribution (must be greater than 0.) |

The result of norminv is the inverse of the NORMDISTCDF function, i.e. NORMINV(NORMDISTCDF(x,5,2),5,2)=x.

____________________________

See also: