Manuals/calci/AVG

From ZCubes Wiki
Revision as of 14:52, 21 November 2016 by Devika (talk | contribs) (→‎Description)
Jump to navigation Jump to search
AVG(array)


  • 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
  • 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.