Difference between revisions of "Manuals/calci/AVERAGE"

Revision as of 04:16, 21 April 2014

AVERAGE(n1,n2,n3,....)

This function gives the Average for given set numbers.
Average means sum of all the given elements divided by Number of given elements.
It is also called Arithmetic mean.
i.e if $n$ numbers are given and each number is denoted by $a_{i}$ , where $i=1$ to $n$ , then

$A.M={\frac {1}{n}}\sum _{i=1}^{n}a_{i}$ = ${\frac {1}{n}}(a_{1}+a_{2}+.....+a_{n})$ .

In this function $n_{1},n_{2},n_{3}...$ can either be numbers,arrays,references of cells or we can enter the logical values directly.
Arithmetic mean is the most common measures of central tendency.
Central tendency is a single value that attempts to describe a set of data by identifying the central position within that set of data.
The other common measures of central tendency are: Median,& Mode.
A.M is calculated by adding the given set of numbers and divided by the count of the given set of numbers.

Average of 2,4,2,7,2,3 and 5 is 3.6

The median of 2,2,2,3,4,5,7 is 3

The mode of 2,2,2,3,4,5 and 7 is 2.

The syntax is to calculate AVERAGE in ZOS is .
- $n_{1},n_{2},n_{3}...$ are any real numbers.
For e.g.,AVERAGE(10..15..0.25)
AVERAGE(-10..-1)

@@ Line 7: / Line 7: @@
 *Average means sum of all the given elements divided by Number of given elements.
 *It is also called Arithmetic mean.
-*i.e if <math>n</math> numbers are given and each number is denoted by <math>ai</math>, where <math>i=1</math> to <math>n</math>, then
+*i.e if <math>n</math> numbers are given and each number is denoted by <math>a_i</math>, where <math>i=1</math> to <math>n</math>, then
 <math>A.M=\frac{1}{n}\sum_{i=1}^n a_i</math> = <math>\frac{1}{n}(a_1+a_2+.....+a_n)</math>.
 *In this function <math>n_1,n_2,n_3...</math> can either be numbers,arrays,references of cells or we can enter the logical values directly.