13-7-11

Cell and List Calculations

ustdDev

Function: Returns the sample standard deviation of the values contained in the range of specified cells.

Syntax: stdDev(start cell:end cell)

Example: To determine the sample standard deviation of the values in the block whose upper left corner is located at A7 and whose lower right corner is located at C12, and input the result in cell A1:

uvariance

Function: Returns the sample variance of the values contained in the range of specified cells.

Syntax: variance(start cell:end cell)

Example: To determine the sample variance of the values in the block whose upper left corner is located at A7 and whose lower right corner is located at C12, and input the result in cell A1:

20090601