beautypg.com

Normsinv, 278 normsinv – Apple iWork '09 User Manual

Page 278

background image

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