Statistical Functions

Return to the Index
AVERAGE | COUNT | COUNTA | MAX | MEDIAN | MIN | PERMUT | RANK | STDEV | STDEVP | VAR | VARP

AVERAGE
Returns the average of all of the arguments.

Syntax:

AVERAGE(number1, ...)

Number1, ... is the list of numbers.

Example:

average(3, 4, 9) equals 5.333333333333333

COUNT
Returns the COUNT of all of the arguments.

Syntax:

COUNT(number1, ...)

Number1, ... is the list of numbers.

Example:

count(3, 4, 9, "", "hi", "3") equals 4

COUNTA
Returns the number of cells or argument values that are not empty.

Syntax:

COUNTA(value1...)

Number1, ... is the list of numbers to multiply.
Value1... arguments representing the values you want to count. If an argument is an array or reference, empty cells within the array or reference are ignored.
Value1, value2, ... are 1 to 30 . In this case, a value is any type of information, including empty text ("") but not including empty cells. If you do not need to count logical values, text, or error values, use the COUNT function.

Example:

counta(3, 4, 9, "", "hi", "3") equals 6

MAX
Returns the MAX of all of the arguments.

Syntax:

MAX(number1, ...)

Number1, ... is the list of numbers.

Example:

max(3, 5, 1, 2) equals 5.0

MEDIAN
Returns the MEDIAN of all of the arguments.

Syntax:

MEDIAN(number1, ...)

Number1, ... is the list of numbers.

Example:

median(6, 3, 9, 4) equals 5.0

MIN
Returns the MIN of all of the arguments.

Syntax:

MIN(number1, ...)

Number1, ... is the list of numbers.

Example:

min(0, 2, -1) equals -1.0

PERMUT
Returns the PERMUT of all of the arguments.

Syntax:

PERMUT(number1, ...)

Number1, ... is the list of numbers.

Example:

permut(3, 2) equals 6

RANK
Returns the RANK of all of the arguments.

Syntax:

RANK(number1, ...)

Number1, ... is the list of numbers.

Example:

RANK(A2,A1:A5,1) equals 1

STDEV
Returns the STDEV of all of the arguments.

Syntax:

STDEV(number1, ...)

Number1, ... is the list of numbers.

Example:

stdev(3, 4, 9) equals 3.2145502536643185

STDEVP
Returns the STDEVP of all of the arguments.

Syntax:

STDEVP(number1, ...)

Number1, ... is the list of numbers.

Example:

stdevp(3, 4, 9) equals 2.6246692913372702

VAR
Returns the VAR of all of the arguments.

Syntax:

VAR(number1, ...)

Number1, ... is the list of numbers.

Example:

var(3, 4, 9) equals 10.333333333333334

VARP
Returns the VARP of all of the arguments.

Syntax:

VARP(number1, ...)

Number1, ... is the list of numbers.

Example:

varp(3, 4, 9) equals 6.888888888888889

Copyright 2003-2005 Diamond Edge, Inc. All rights reserved.