NORMINV - script and chart function

NORMINV() returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Syntax:  

NORMINV(prob, mean, standard_dev)

Return data type: number

Arguments:  

Argument Description
prob A probability associated with the normal distribution. It must be a number between 0 and 1.
mean A value stating the arithmetic mean for the distribution.
standard_dev A positive value stating the standard deviation of the distribution.

This function is related to the NORMDIST function in the following way:
If prob = NORMDIST(value, m, sd), then NORMINV(prob, m, sd) = value

Limitations:  

All arguments must be numeric, else NULL will be returned.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?