Spread 8.0 Documentation
NORMINV
Support Options
Formula Reference > Built-In Functions > NORMINV

Glossary Item Box

NORMINV


Name

Inverse normal distribution

Description

Returns the inverse of the normal cumulative distribution for the given mean and standard deviation.

Syntax

NORMINV(prob,mean,stdev)

Remarks

This function has the following arguments:

Argument Description
prob Probability of the normal distribution
mean Arithmetic mean of the distribution
stdev Standard deviation of the distribution. Must be greater than zero

Data Type

Accept numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

NORMINV(B3,C12,D14)
NORMINV(R3C1,R12C3,R14C4)
NORMINV(0.978,32,0.252)=32.50755174

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.