Difference between revisions of "Manuals/calci/AVG"
Jump to navigation
Jump to search
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''AVG( | + | <div style="font-size:30px">'''AVG()'''</div><br/> |
| − | * | + | *Parameters are any set of real numbers. |
==Description== | ==Description== | ||
| Line 6: | Line 6: | ||
*Average means sum of all the given elements is divided by Number of the given elements. | *Average means sum of all the given elements is divided by Number of the given elements. | ||
*It is also called Arithmetic mean. | *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 | + | *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= \frac{1}{n} \sum_{i=1}^n (a_i)= \frac{1}{n}(a_1+a_2+.....+a_n)</math> |
| − | + | *In this function <math>array</math> 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. | *This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers. | ||
| + | |||
| + | ==Examples== | ||
| + | #AVG(1,2,3,4,5,6,7,8,9,10) = 5.5 | ||
| + | #AVG(201..624) = 412.5 | ||
| + | # AVG(1000..34521) = 17760.5 | ||
| + | #n=10;[SUM(1..n),AVG(1..n)] = 55 5.5 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=Gp0F_WuZFwM|280|center|AVERAGE}} | ||
| + | |||
| + | ==See Also== | ||
| + | |||
| + | *[[Manuals/calci/SUM | SUM]] | ||
| + | *[[Manuals/calci/AVERAGE | AVERAGE ]] | ||
| + | *[[Manuals/calci/AVERAGEA | AVERAGEA ]] | ||
| + | |||
| + | ==References== | ||
| + | [http://en.wikipedia.org/wiki/Average| Average] | ||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 02:01, 30 June 2021
AVG()
- Parameters are any 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 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.
, where i=1 to n, then 
are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.Examples
- AVG(1,2,3,4,5,6,7,8,9,10) = 5.5
- AVG(201..624) = 412.5
- AVG(1000..34521) = 17760.5
- n=10;[SUM(1..n),AVG(1..n)] = 55 5.5
Related Videos
See Also
References