Manuals/calci/AVERAGEMIDDLE

AVERAGEMIDDLE (Range,TopCount)

$Range$ can be any set of real numbers.
can be number of numbers from top.
- AVERAGE(), returns the average of its arguments.

Description

This function gives the Average for given set of numbers from the top.
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,the parameters 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.