beautypg.com

Stdeva, 291 stdeva – Apple iWork '09 User Manual

Page 291

background image

Chapter 10

Statistical Functions

291

“STDEVPA” on page 294

VAR” on page 298

VARA” on page 300

VARP” on page 302

VARPA” on page 303

“Survey Results Example” on page 362

“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

STDEVA

The STDEVA function returns the standard deviation, a measure of dispersion, of a
collection of values that may include text and Boolean values, based on the sample
(unbiased) variance.

STDEVA(value, value…)

Â

value: A value. value can contain any value type. All numeric values must be of the
same type. You cannot mix numbers, dates, and duration values.

Â

value…:  One or more additional values (a minimum of two values are required).
All numeric values must be of the same type. You cannot mix numbers, dates, and
duration values.

Usage Notes

It is appropriate to use STDEVA when the specified values represent only a sample

Â

of a larger population. If the values you are analyzing represent the entire collection
or population, use the STDEVPA function.
STDEVA assigns a value of 0 to any text value, 0 to the Boolean value FALSE, and 1

Â

to the Boolean value TRUE and includes them in the computation. Empty cells are
ignored. If you do not want to include text or Boolean values in the computation,
use the STDEV function.
The standard deviation is the square root of the variance returned by the VARA function.

В