Difference between revisions of "Manuals/calci/AVG"
Jump to navigation
Jump to search
(Created page with "==AVG==") |
|||
| Line 1: | Line 1: | ||
| − | == | + | <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= 1/n sum_{i=1}^n (a_i)= 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. | ||
Revision as of 13:47, 21 November 2016
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= 1/n sum_{i=1}^n (a_i)= 1/n(a
, where i=1 to n, then <math>A.M= 1/n sum_{i=1}^n (a_i)= 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.