Difference between revisions of "Manuals/calci/MEAN"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 14: Line 14:
 
#AVG(201..624) = 412.5
 
#AVG(201..624) = 412.5
 
# AVG(1000..34521) = 17760.5
 
# AVG(1000..34521) = 17760.5
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=Gp0F_WuZFwM|280|center|Mean}}
  
 
==See Also==
 
==See Also==

Latest revision as of 16:45, 29 November 2018

AVG()


  • Parameters are any set of real numbers.

Description

  • This function gives the Average or Mean for given set numbers.
  • Average defines the 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
  • In this function 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

  1. AVG(1,2,3,4,5,6,7,8,9,10) = 5.5
  2. AVG(201..624) = 412.5
  3. AVG(1000..34521) = 17760.5

Related Videos

Mean

See Also

References

Average