Difference between revisions of "Manuals/calci/AVERAGE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">'''AVERAGE''' (A1, A2...)</fo...") |
|||
| (35 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''AVERAGE()'''</div><br/> |
| − | |||
| − | |||
| − | 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 <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 | ||
| + | <math>A.M=\frac{1}{n}\sum_{i=1}^n a_i</math> = <math>\frac{1}{n}(a_1+a_2+.....+a_n)</math>. | ||
| + | *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, | ||
| + | #when the values are error values or text that cannot change in to numbers. | ||
| − | + | ==ZOS== | |
| − | </ | + | *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== | |
| − | AVERAGE ( | + | *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== | |
| + | {{#ev:youtube|9VZsMY15xeU|280|center|Average}} | ||
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/AVEDEV | AVEDEV ]] | |
| + | *[[Manuals/calci/AVERAGEA | AVERAGEA ]] | ||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| − | + | ==References== | |
| + | [http://en.wikipedia.org/wiki/Average| Average] | ||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 04: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
numbers are given and each number is denoted by 
, where 
to = .
= 
.
- 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,
- 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)
.
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
See Also
References