writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
==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]