Manuals/calci/AVERAGEIF

AVERAGEIF (Array,Condition,SumArray)

• $Array$ is the set of values.
• $Condition$ is any condition value.

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

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle A.M=\frac{1}{n}\sum_{i=1}^n a_i} = Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \frac{1}{n}(a_1+a_2+.....+a_n)} .

• In this function Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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

Examples

1. AVERAGEIF([2,3,11,13,17,26,34,47],">5") = 24.666666666666668
2. AVERAGEIF([154,876,143,12.4,90,54.7],"<798") = 90.82
3. AVERAGEIF([-20,87,-99,67.4],">0") = 77.2

Related Videos

AVERAGEIF

See Also

• AVERAGE
• AVEDEV
• AVERAGEA

References

• Average

• List of Main Z Functions

• Z3 home