Difference between revisions of "Manuals/calci/AVERAGE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">'''AVERAGE''' (A1, A2...)</fo...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''AVERAGE(n1,n2,n3)'''</div><br/> |
| − | |||
| − | |||
| − | + | *Where N1,N2,N3 .... are any 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 ai, | ||
| + | *where i=1 to n, then A.M= 1/n Summation i=1 to n (ai)= 1/n(a1+a2+.....+an). | ||
| + | *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. | ||
| + | *Also if the distribution is symmetric, then we can use this function to find the central tendency. | ||
| + | *The three most common measures of central tendency are: A.M, Median,& Mode.A.M: | ||
| + | *It is calculating by adding the given set of numbers and divided by the count of the given set of numbers. *E.g:Average of 2,4,2,7,2,3 and 5 is 3.6 | ||
| + | *Median: It is the middle number of a sorted list(Ascending order) of numbers. | ||
| + | *E.g:The median of 2,2,2,3,4,5,7 is 3 | ||
| + | *Mode: It is the most frequently repeated number in a given set of numbers. | ||
| + | *E.g.The mode of 2,2,2,3,4,5 and 7 is 2 | ||
| − | + | ==Examples== | |
| − | + | *AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47)=19.125 | |
| − | + | *AVERAGE(5,-2,7,8,11,20,25,-9)=8.125 | |
| − | -- | ||
| − | |||
| − | |||
| − | |||
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/AVEDEV | AVEDEV ]] | |
| + | *[[Manuals/calci/AVERAGEA | AVERAGEA ]] | ||
| − | |||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 04:37, 19 November 2013
AVERAGE(n1,n2,n3)
- Where N1,N2,N3 .... are any 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 ai,
- where i=1 to n, then A.M= 1/n Summation i=1 to n (ai)= 1/n(a1+a2+.....+an).
- 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.
- Also if the distribution is symmetric, then we can use this function to find the central tendency.
- The three most common measures of central tendency are: A.M, Median,& Mode.A.M:
- It is calculating by adding the given set of numbers and divided by the count of the given set of numbers. *E.g:Average of 2,4,2,7,2,3 and 5 is 3.6
- Median: It is the middle number of a sorted list(Ascending order) of numbers.
- E.g:The median of 2,2,2,3,4,5,7 is 3
- Mode: It is the most frequently repeated number in a given set of numbers.
- E.g.The mode of 2,2,2,3,4,5 and 7 is 2
Examples
- AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47)=19.125
- AVERAGE(5,-2,7,8,11,20,25,-9)=8.125
See Also