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. 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 |