beautypg.com

Lognormdist, 269 lognormdist – Apple iWork '09 User Manual

Page 269

background image

Chapter 10

Statistical Functions

269

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

LOGNORMDIST

The LOGNORMDIST function returns the log-normal distribution.

LOGNORMDIST(pos-x-value, mean, stdev)

Â

pos-x-value: The positive x value at which you want to evaluate the function. pos-x-
value
is a number value that must be greater than 0.

Â

mean: The mean of the natural logarithm, that is, ln

(x)

. mean is a number value and

is the average (arithmetic mean) of ln

(x)

; the natural logarithm of x.

Â

stdev: The standard deviation of the population. stdev is a number value and must
be greater than 0.

Example

=LOGNORMDIST(0.78, 1.7, 2.2) returns 0.187899237956868.

Related Topics
For related functions and additional information, see:

“LN” on page 179

“LOGINV” on page 268

“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