Apple numbers User Manual

    Dictionary of Functions 

 

  

The SQRT function calculates the square root of a number.

SQRT(number)

 number:  A nonnegative numeric expression.

  

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.

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.

SQRT(16) returns 4.

SQRT(12.25) returns 3.5, the square root of 12.25.