Manuals/calci/AVERAGE

From ZCubes Wiki
Revision as of 04:37, 19 November 2013 by Jayaram (talk | contribs)
Jump to navigation Jump to search
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


References

Complex Numbers