Apple numbers 用户手册

 Dictionary of Functions

 

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

Calculates event rate probabilities based on the Poisson 
distribution.

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

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.

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.