Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

NORMINV

Description: Returns the inverse of the normal cumulative distribution.

Syntax: NORMINV(Probability, Mean, Standard_dev)

• Probability is a probability corresponding to the normal distribution.

• Mean is the arithmetic mean of the distribution.

• Standard_dev is the standard deviation of the distribution.

Remarks:

• All arguments must be numerical.

• Probability must be =>0 and <= 1.

• Standard_dev must be > 0.

• If Mean = 0 and Standard_dev = 1, NORMINV uses the standard normal distribution (see NORMSINV).

Example:

• NORMINV(0.908789, 40, 1.5) = 42