writer
6,694
edits
Changes
Jump to navigation
Jump to search
Created page with "<div style="font-size:30px">'''AVERAGEIF (Array,Condition,SumArray)'''</div><br/> *<math>Array</math> is the set of values. *<math>Condition</math> is any condition value. =..."
<div style="font-size:30px">'''AVERAGEIF (Array,Condition,SumArray)'''</div><br/>
*<math>Array</math> is the set of values.
*<math>Condition</math> is any condition value.
==Description==
*This function shows the Average of given set of numbers which satisfies the given condition.
*In <math>AVERAGEIF (Array,Condition,SumArray)</math>,<math>Array</math> 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 <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.
*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==
#AVERAGEIF([2,3,11,13,17,26,34,47],">5") = 24.666666666666668
#AVERAGEIF([154,876,143,12.4,90,54.7],"<798") = 90.82
#AVERAGEIF([-20,87,-99,67.4],">0") = 77.2
==See Also==
*[[Manuals/calci/ AVERAGE | AVERAGE ]]
*[[Manuals/calci/AVEDEV | AVEDEV ]]
*[[Manuals/calci/AVERAGEA | AVERAGEA ]]
==References==
*[http://en.wikipedia.org/wiki/Average| Average]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
*<math>Array</math> is the set of values.
*<math>Condition</math> is any condition value.
==Description==
*This function shows the Average of given set of numbers which satisfies the given condition.
*In <math>AVERAGEIF (Array,Condition,SumArray)</math>,<math>Array</math> 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 <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.
*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==
#AVERAGEIF([2,3,11,13,17,26,34,47],">5") = 24.666666666666668
#AVERAGEIF([154,876,143,12.4,90,54.7],"<798") = 90.82
#AVERAGEIF([-20,87,-99,67.4],">0") = 77.2
==See Also==
*[[Manuals/calci/ AVERAGE | AVERAGE ]]
*[[Manuals/calci/AVEDEV | AVEDEV ]]
*[[Manuals/calci/AVERAGEA | AVERAGEA ]]
==References==
*[http://en.wikipedia.org/wiki/Average| Average]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]