Manuals/calci/AVERAGEIF

AVERAGEIF (Array,Condition,SumArray)

Description

This function shows the Average of given set of numbers which satisfies the given condition.
In $AVERAGEIF(Array,Condition,SumArray)$ , $Array$ is the given set of numbers.
Condition is a number, expression, cell reference, or text.
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.
So this function calculates the average value which satisfies the given condition.
For example AVERAGEIF([10,20,23.3,67,87,98.3,12.3,45.3,90],"<13") =11.15