Devika: Created page with "
'''AVERAGETOP (Range,TopCount) '''

* $Range$ can be any set of real numbers. * $TopCount$ can be number of numbers..."

2018-12-27T23:28:21Z

Created page with "<div style="font-size:30px">'''AVERAGETOP (Range,TopCount) '''</div><br/> *<math>Range</math>can be any set of real numbers. *<math>TopCount</math> can be number of numbers..."

New page

<div style="font-size:30px">'''AVERAGETOP (Range,TopCount) '''</div><br/>

*<math>Range</math>can be any set of real numbers.
*<math>TopCount</math> can be number of numbers from top.
**AVERAGE(), returns the average of its arguments.

==Description==

*This function gives the Average for given set of numbers from the top.
*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.

==Examples==

*AVERAGETOP([18,23,87,45,56,17,26,67,19,20],4) = 43.25
*AVERAGETOP([5,-2,7,8,11,20,25,-9,12,18,23,76,89,129,98],7) = 10.571428571428571

==Related Videos==
{{#ev:youtube|9VZsMY15xeU|280|center|Average}}

==See Also==

*[[Manuals/calci/AVERAGE | AVERAGE ]]
*[[Manuals/calci/AVERAGEBOTTOM | AVERAGEBOTTOM ]]
*[[Manuals/calci/AVERAGEA | AVERAGEA]]

==References==
[http://en.wikipedia.org/wiki/Average| Average]

*[[Z_API_Functions | List of Main Z Functions]]

*[[ Z3 | Z3 home ]]

Manuals/calci/AVERAGETOP - Revision history

Devika: Created page with "'''AVERAGETOP (Range,TopCount) ''' *Rangecan be any set of real numbers. *TopCount can be number of numbers..."

Devika: Created page with "
'''AVERAGETOP (Range,TopCount) '''

* $Range$ can be any set of real numbers. * $TopCount$ can be number of numbers..."