Difference between revisions of "Manuals/calci/AVERAGE"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
<div style="font-size:30px">'''AVERAGE(n_1,n_2,n_3,....)'''</div><br/>
+
<div style="font-size:30px">'''AVERAGE(n1,n2,n3,....)'''</div><br/>
  
*Where <math>n1,n2,n3...</math> are any real numbers.  
+
*<math>n_1,n_2,n_3...</math> are any real numbers.  
  
 
==Description==
 
==Description==
Line 21: Line 21:
 
*This function will show the result as Error,
 
*This function will show the result as Error,
 
#when the values are error values or text that cannot change in to numbers.
 
#when the values are error values or text that cannot change in to numbers.
 +
 +
==ZOS Section==
 +
 +
*The syntax is to calculate AVERAGE in ZOS is <math>AVERAGE(n_1,n_2,n_3,...)</math>.
 +
**<math>n_1,n_2,n_3...</math> are any real numbers.
 +
*For e.g.,AVERAGE(10..15..0.25)
 +
*AVERAGE(-10..-1)
  
 
==Examples==
 
==Examples==

Revision as of 05:12, 21 April 2014

AVERAGE(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 divided by Number of given elements.
  • It is also called Arithmetic mean.
  • i.e if numbers are given and each number is denoted by , where to , then

= .

  • In this function can either be numbers,arrays,references of cells or we can enter the logical values directly.
  • Arithmetic mean is the most common measures of central tendency.
  • Central tendency is a single value that attempts to describe a set of data by identifying the central position within that set of data.
  • The other common measures of central tendency are: Median,& Mode.
  • A.M is calculated by adding the given set of numbers and divided by the count of the given set of numbers.
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.
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.
The mode of 2,2,2,3,4,5 and 7 is 2.
  • This function will show the result as Error,
  1. when the values are error values or text that cannot change in to numbers.

ZOS Section

  • The syntax is to calculate AVERAGE in ZOS is .
    • are any real numbers.
  • For e.g.,AVERAGE(10..15..0.25)
  • AVERAGE(-10..-1)

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

Average