Manualshelf

Owner manual

ManualsBrandsApple ManualsSoftwareiWork '09
281282283284285286287288289290
Chapter 10 Statistical Functions 289
“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
STANDARDIZE
The STANDARDIZE function returns a normalized value from a distribution
characterized by a given mean and standard deviation.
STANDARDIZE(num, average, stdev)
 num: The number to be evaluated. num is a number value.
 average: The average of the distribution. average is a number value representing
the known average (arithmetic mean) rate at which events occur.
 stdev: The standard deviation of the population. stdev is a number value and must
be greater than 0.
Example
=STANDARDIZE(6, 15, 2.1) returns –4.28571428571429.
Related Topics
For related functions and additional information, see:
“NORMDIST” on page 276
“NORMINV” on page 277
“NORMSDIST” on page 277
“NORMSINV” on page 278
“ZTEST” on page 305
“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