Difference between revisions of "Manuals/calci/AVG"

Latest revision as of 02:01, 30 June 2021

AVG()

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: @@
-<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==
@@ Line 7: / Line 7: @@
 *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 N1,N2,... are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
+*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
+#n=10;[SUM(1..n),AVG(1..n)] = 55       	5.5
+==Related Videos==
+{{#ev:youtube|v=Gp0F_WuZFwM|280|center|AVERAGE}}
+==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 ]]