Formulas and Functions

Example
=NORMSDIST(4.3) returns 0.999991460094529.
Related Topics
For related functions and additional information, see:
“NORMDIST” on page 276
“NORMSINV” on page 278
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
NORMSINV
The NORMSINV function returns the inverse of the cumulative standard normal
distribution.
NORMSINV(probability)
 probability: A probability associated with the distribution. probability is a number
value and must be greater than 0 and less than 1.
Usage Notes
A standard normal distribution has an average (arithmetic mean) of 0 and a Â
standard deviation of 1.
Example
=NORMSINV(0.89) returns 1.22652812003661.
Related Topics
For related functions and additional information, see:
“NORMINV” on page 277
“NORMSDIST” on page 277
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
278 Chapter 10 Statistical Functions