Statistical function
NORM.INV Function
Returns the X value from a normal distribution, given a
cumultive probability.
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
The Father of Spreadsheet Dashboard Reports

This function replaces the
NORMINV function.
The NORM.DIST function
returns the inverse of this function. That is, given the X
value, mean, and standard deviation of a normal curve, NORM.DIST
returns either the cumulative or noncumulative probability value.
Syntax
=NORM.INV(probability,mean,standard_dev)
 probability A probability from the
normal distribution.
 mean The arithmetic mean of the
normal distribution.
 standard_dev The standard
deviation of the normal distribution.
Applies To
Excel 2007 and above.
Remarks
 All values must be numeric.
 The probabiity must be betwen 0 and 1, inclusive.
 The standard deviation must be greater than zero.
 If the mean equals zero and the standard deviation
equals 1, NORM.INV uses the standard normal distribution. (See
NORM.S.INV.)
Examples
Other ExcelUser
Information
Other Help
