Manuals/calci/AVG
AVG(array)
- are set of real numbers.
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 , 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).
- In this function N1,N2,... 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.
, 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).