Difference between revisions of "Manuals/calci/MEAN"

Latest revision as of 15:45, 29 November 2018

AVG()

This function gives the Average or Mean for given set numbers.
Average defines the sum of all the given elements is divided by Number of the 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 $array$ are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.

@@ Line 1: / Line 1: @@
-==mean
+<div style="font-size:30px">'''AVG()'''</div><br/>
+*Parameters are any set of real numbers.
+==Description==
+*This function gives the Average or Mean for given set numbers.
+*Average defines the  sum of all the given elements is divided by Number of the given elements.
+*It is also called Arithmetic mean.
+*i.e.If n numbers are given and each number is denoted by <math>a_i</math>, where i=1 to n, then <math>A.M= \frac{1}{n} \sum_{i=1}^n  (a_i)= \frac{1}{n}(a_1+a_2+.....+a_n)</math>
+*In this function <math>array</math> are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
+*This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.
+==Examples==
+#AVG(1,2,3,4,5,6,7,8,9,10) = 5.5
+#AVG(201..624) = 412.5
+# AVG(1000..34521) = 17760.5
+==Related Videos==
+{{#ev:youtube|v=Gp0F_WuZFwM|280|center|Mean}}
+==See Also==
+*[[Manuals/calci/SUM | SUM]]
+*[[Manuals/calci/AVERAGE  | AVERAGE ]]
+*[[Manuals/calci/AVERAGEA  | AVERAGEA ]]
+==References==
+[http://en.wikipedia.org/wiki/Average| Average]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]