| Name: |
AVEDEV |
| Syntax: |
AVEDEV(<num1> [, <num2> ...]) |
| Description: |
Returns the average of the absolute deviations of data points from their mean. |
| Version: |
3.3 |
| Example: |
AVEDEV(1, a1, {2, 3}) |
| Name: |
AVERAGE |
| Syntax: |
AVERAGE(<numbers>[,< numbers >]*) |
| Description: |
Returns the average value of all the number arguments. References to empty and non-number cells are ignored. |
| Version: |
1.0 |
| Example: |
AVERAGE(A1:C3)
AVERAGE(A1,B2,B3)
AVERAGE(1.2,2.3,3.4)
AVERAGE(2*3, SUM(A1,A2)) |
| Name: |
AVERAGEA |
| Syntax: |
AVERAGEA(<numbers>[,< numbers >]*) |
| Description: |
Returns the average of all the arguments. Text and FALSE arguments evaluate to zero. TRUE evaluates to 1. |
| Version: |
3.0 |
| Name: |
LARGE |
| Syntax: |
LARGE(<values>,n) |
| Description: |
Returns the nth largest value in a data set. |
| Version: |
3.0 |
| Name: |
MEDIAN |
| Syntax: |
MEDIAN(<numbers>[,<numbers]*) |
| Description: |
Returns the median of all the number arguments. Ignores arguments that do not evaluate to a number. |
| Version: |
1.0 |
| Example: |
MEDIAN(1) Evaluates to 1
MEDIAN(1,2) Evaluates to 1.5
MEDIAN(1,2,100) Evaluates to 2 |
| Name: |
MODE |
| Syntax: |
MODE(<numbers>[,<numbers>]*) |
| Description: |
Returns the mode of all number arguments passed in. Arguments that do not evaluate to a number are ignored. |
| Version: |
1.0 |
| Example: |
MODE(1) Evaluates to 1
MODE(1,2) Evaluates to 1
MODE(1,2,2) Evaluates to 2 |
| Name: |
NORMDIST |
| Syntax: |
NORMDIST(x, mean, standard_dev, cumulative) |
| Description: |
Returns the normal distribution for the specified mean and standard deviation.
Note that cumulative distribution is not currently supported. |
| Version: |
1.3 |
| Name: |
SMALL |
| Syntax: |
SMALL(<values>,n) |
| Description: |
Returns the nth smallest value in a data set. |
| Version: |
3.0 |
| Name: |
STDEV |
| Syntax: |
STDEV(<numbers>[,<numbers>]*) |
| Description: |
Returns the standard deviation of the numbers in the sample. The equation used is sqrt(sum((x-average(x))^2) / (n-1)) where x is each number and n is the size of the sample. Only numeric values are used. |
| Version: |
1.1 |
| Example: |
STDEV(a1:c3)
STDEV(1, 2, 3, 4) |
| Name: |
STDEVA |
| Syntax: |
STDEVA(<numbers>[,<numbers>]*) |
| Description: |
Returns the standard deviation of the numbers in the sample. The equation used is sqrt(sum((x-average(x))^2) / (n-1)) where x is each number and n is the size of the sample. Numeric, logical and text values are used. |
| Version: |
1.1 |
| Example: |
STDEVA(a1:c3)
STDEVA(1, 2, 3, 4) |
| Name: |
STDEVP |
| Syntax: |
STDEVP(<numbers>[,<numbers>]*) |
| Description: |
Returns the standard deviation of the numbers in the whole population. The equation used is sqrt(sum((x-average(x))^2) / n) where x is each number and n is the size of the population. Only numeric values are used. |
| Version: |
1.1 |
| Example: |
STDEVP(a1:c3)
STDEVP(1, 2, 3, 4) |
| Name: |
STDEVPA |
| Syntax: |
STDEVPA(<numbers>[,<numbers>]*) |
| Description: |
Returns the standard deviation of the numbers in the whole population. The equation used is sqrt(sum((x-average(x))^2) / n) where x is each number and n is the size of the population. Numeric, logical and text values are used. |
| Version: |
1.1 |
| Example: |
STDEVPA(a1:c3)
STDEVPA(1, 2, 3, 4) |
| Name: |
VAR |
| Syntax: |
VAR(<value1> [, <value2> ...]) |
| Description: |
Calculates the variance based on a sample. Excludes logical values and text. |
| Version: |
3.3 |
| Example: |
VAR(1, 2) |
| Name: |
VARA |
| Syntax: |
VARA(<value1> [, <value2> ...]) |
| Description: |
Calculates the variance based on a sample, including logical values and text. Text and FALSE have the value 0. TRUE has the value 1. |
| Version: |
3.3 |
| Example: |
VARA(1, 2, TRUE, "abc") |
| Name: |
VARP |
| Syntax: |
VARP(<value1> [, <value2> ...]) |
| Description: |
Calculates the variance based on the entire population. Excludes logical values and text. |
| Version: |
3.3 |
| Example: |
VARP(1, 2) |
| Name: |
VARPA |
| Syntax: |
VARPA(<value1> [, <value2> ...]) |
| Description: |
Calculates the variance based on the entire population, including logical values and text. Text and FALSE have the value 0. TRUE has the value 1. |
| Version: |
3.3 |
| Example: |
VARPA(1, 2, TRUE, "abc") |