Difference between revisions of "Manuals/calci/AVG"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "==AVG==")
 
Line 1: Line 1:
==AVG==
+
<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.

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

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