In This Topic

NORMINV

In This Topic

This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation.

NORMINV(*prob*,*mean*,*stdev*)

This function has these arguments:

Argument | Description |
---|---|

prob |
Probability of the normal distribution |

mean |
Arithmetic mean of the distribution |

stdestdev |
Standard deviation of the distribution Must be greater than zero. |

Accepts numeric data for all arguments. Returns numeric data.

NORMINV(B3,C12,D14)

NORMINV(R3C2,R12C3,R14C4)

NORMINV(0.978,32,0.252) gives the result 32.50755174

This function is available in product version 1.0 or later.

NORMDIST | NORMSINV | Statistical Functions