Difference between revisions of "Manuals/calci/MEAN"

Revision as of 14:39, 29 November 2016

AVG(array)

This function gives the Average for given set numbers.
Average means 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(array)'''</div><br/>
+*<math>array</math> are set of real numbers.
+==Description==
+*This function gives the Average for given set numbers.
+*Average means 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
+==See Also==
+*[[Manuals/calci/SUM | SUM]]
+*[[Manuals/calci/AVERAGE  | AVERAGE ]]
+*[[Manuals/calci/AVERAGEA  | AVERAGEA ]]
+==References==
+[http://en.wikipedia.org/wiki/Average| Average]