Filter
Top Products
20050501
uu
uu
u variance
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:
13-6-9
Using the Action Menu
uu
uu
u Q1
Function: Returns the first quartile of the values contained in the range of specified cells.
Syntax: Q1(start cell:end cell[,start cell:end cell])
Example: To determine the first quartile 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: