Difference between revisions of "Manuals/calci/MEAN"

Latest revision as of 16: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: @@
-<div style="font-size:30px">'''AVG(array)'''</div><br/>
+<div style="font-size:30px">'''AVG()'''</div><br/>
-*<math>array</math> are set of real numbers.
+*Parameters are any set of real numbers.
 ==Description==
-*This function gives the Average for given set numbers.
+*This function gives the Average or Mean for given set numbers.
-*Average means sum of all the given elements is divided by Number of the given elements.
+*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>
@@ Line 14: / Line 14: @@
 #AVG(201..624) = 412.5
 # AVG(1000..34521) = 17760.5
+==Related Videos==
+{{#ev:youtube|v=Gp0F_WuZFwM|280|center|Mean}}
 ==See Also==
@@ Line 23: / Line 27: @@
 ==References==
 [http://en.wikipedia.org/wiki/Average| Average]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]