Difference between revisions of "Manuals/calci/AVERAGE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(27 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''AVERAGE(n1,n2,n3)'''</div><br/>
+
<div style="font-size:30px">'''AVERAGE()'''</div><br/>
  
−
*Where <math>n1,n2,n3...</math> are any real numbers.  
+
*Parameters are any set of real numbers.
 +
**AVERAGE(), returns the average of its arguments.
  
 
==Description==
 
==Description==
 +
 
*This function gives the Average for given set numbers.  
 
*This function gives the Average for given set numbers.  
 
*Average means sum of all the given elements divided by Number of given elements.
 
*Average means sum of all the given elements divided by Number of given elements.
−
*It is also called Arithmetic mean. i.e if <math>n</math> numbers are given and each number is denoted by ai, where <math>i=1</math> to <math>n</math>, then  
+
*It is also called Arithmetic mean.  
−
<math>A.M=\frac{1}{n}\sum_{i=1}^n ai</math> = <math>\frac{1}{n}(a1+a2+.....+an)</math>.  
+
*i.e if <math>n</math> numbers are given and each number is denoted by <math>a_i</math>, where <math>i=1</math> to <math>n</math>, then  
−
*In this function N1,N2,... are either it can be numbers,arrays ,references of cells or  
+
<math>A.M=\frac{1}{n}\sum_{i=1}^n a_i</math> = <math>\frac{1}{n}(a_1+a_2+.....+a_n)</math>.  
−
*we can enter the logical values directly. This function will show .the result as Error ,
+
*In this function,the parameters can either be numbers,arrays,references of cells or we can enter the logical values directly.
−
*when the numbers are error values or text that cannot change in to numbers.  
+
*Arithmetic mean is the most common measures of central tendency.
−
*Also if the distribution is symmetric, then we can use this function to find the 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 three most common measures of central tendency are: A.M, Median,& Mode.A.M: 
+
*The other common measures of central tendency are: Median,& Mode.
−
*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
+
*A.M is calculated by adding the given set of numbers and divided by the count of the given set of numbers.  
−
*Median: It is the middle number of a sorted list(Ascending order) of numbers.  
+
Average of 2,4,2,7,2,3 and 5 is 3.6
−
*E.g:The median of 2,2,2,3,4,5,7 is 3
+
*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.  
 
*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
+
The mode of 2,2,2,3,4,5 and 7 is 2.
 +
*This function will show the result as Error,
 +
#when the values are error values or text that cannot change in to numbers.
 +
 
 +
==ZOS==
  
−
<math>\sum_{k=1}^N k^2</math>
+
*The syntax is to calculate AVERAGE in ZOS is <math>AVERAGE()</math>.
 +
**Parameters are any set of real numbers.
 +
*For e.g.,AVERAGE(10..15..0.25)
 +
*AVERAGE(-10..-1)
 +
{{#ev:youtube|zjVqIBXC4Q4|280|center|Average}}
  
 
==Examples==
 
==Examples==
  
−
*AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47)=19.125
+
*AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47) = 19.125
 +
*AVERAGE(5,-2,7,8,11,20,25,-9) = 8.125
 +
*AVG(2cm,200m) = 100.01m
 +
*AVG(3kg,2000g,3000mg) = 1667666.6666666667mg
  
−
*AVERAGE(5,-2,7,8,11,20,25,-9)=8.125
+
==Related Videos==
 +
{{#ev:youtube|9VZsMY15xeU|280|center|Average}}
  
 
==See Also==
 
==See Also==
Line 31: Line 46:
 
*[[Manuals/calci/AVEDEV  | AVEDEV ]]
 
*[[Manuals/calci/AVEDEV  | AVEDEV ]]
 
*[[Manuals/calci/AVERAGEA  | AVERAGEA ]]
 
*[[Manuals/calci/AVERAGEA  | AVERAGEA ]]
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
==References==
 +
[http://en.wikipedia.org/wiki/Average| Average]
  
  
−
==References==
+
 
−
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
+
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |   Z3 home ]]

Latest revision as of 05:48, 30 March 2020

AVERAGE()


  • Parameters are any set of real numbers.
    • AVERAGE(), returns the average of its arguments.

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,the parameters 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

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

Examples

  • AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47) = 19.125
  • AVERAGE(5,-2,7,8,11,20,25,-9) = 8.125
  • AVG(2cm,200m) = 100.01m
  • AVG(3kg,2000g,3000mg) = 1667666.6666666667mg

Related Videos

Average

See Also

References

Average


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/AVERAGE&oldid=213284"