beautypg.com

Apple Numbers '08 User Manual

Page 203

background image

Chapter 12

Dictionary of Functions

203

PERCENTILE (page 256)

Finds the value within a range of values that corresponds to a
particular percentile.

POISSON (page 257)

Calculates event rate probabilities based on the Poisson
distribution.

PROB (page 261)

Calculates the probability of a range of values if you know the
individual probability of each value.

RANK (page 264)

Finds the rank of a number within a range of numbers.

SLOPE (page 273)

Finds the slope of the best-fit line for a data set based on linear
regression analysis.

SMALL (page 273)

Retrieves the nth-smallest value in a range.

STDEV (page 274)

Calculates the standard deviation of a set of numbers based on the
sample (unbiased) variance.

STDEVA (page 275)

Calculates the standard deviation of a set of values, including text
and Boolean values, based on the sample (unbiased) variance.

STDEVP (page 275)

Calculates the standard deviation of a set of numbers based on the
population (true) variance.

STDEVPA (page 276)

Calculates the standard deviation of a set of values, including text
and Boolean values, based on the population (true) variance.

VAR (page 284)

Calculates the sample (unbiased) variance of a set of numbers.

VARA (page 285)

Calculates the sample (unbiased) variance of a set of values,
including text and Boolean values.

VARP (page 286)

Calculates the population (true) variance of a set of numbers.

VARPA (page 286)

Calculates the population (true) variance of a set of values,
including text and Boolean values.

Function

Description