Difference between revisions of "Manuals/calci/MEAN"
Jump to navigation
Jump to search
Line 23: | Line 23: | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Average| Average] | [http://en.wikipedia.org/wiki/Average| Average] | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | [[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | [[ Z3 | Z3 home ]] |
Revision as of 05:23, 9 March 2017
AVG(array)
- are set of real numbers.
Description
- This function gives the Average or Mean for given set numbers.
- Average defines the 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.
Examples
- AVG(1,2,3,4,5,6,7,8,9,10) = 5.5
- AVG(201..624) = 412.5
- AVG(1000..34521) = 17760.5
See Also
References