Apple Numbers '08 - Manual (Page 274)

274 Chapter 12 Dictionary of Functions
SQRT
The SQRT function calculates the square root of a number.
SQRT(number)
 number: A nonnegative numeric expression.
STDEV
The STDEV function calculates the standard deviation of a set of values based on their
sample (unbiased) variance. This is appropriate when the specified values represent
only a sample of a larger population.
STDEV(number, [number, . . .])
 number: One or more numbers or cell references.
Notes
The standard deviation is the square root of the variance returned by the VAR function.
If the values you are analyzing represent the entire data set or population, you might
want to use the STDEVP function instead.
Cells that don’t contain numbers are ignored. If you want to include text or Boolean
values in the computation, use the STDEVA function.
Examples
Given the following table:
SMALL(A2:E2, 1) returns 10, the smallest value in the array.
SMALL(A2,E2, 2) returns 20, the third-smallest value in the array.
SMALL(A2:E2, 5) returns 50, the longest value in the array.
SMALL(A1:A5, 0) displays an error; rank must be greater than 0.
SMALL(A1:A5, 6) displays an error; you can’t find the sixth out of five values.
Examples
SQRT(16) returns 4.
SQRT(12.25) returns 3.5, the square root of 12.25.