Devika at 09:17, 11 August 2020

2020-08-11T09:17:34Z

Devika at 06:48, 10 August 2020

2020-08-10T06:48:20Z

Joseph: Created page with "
'''AVERAGEMIDDLE (Range,TopCount) '''

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

2020-02-04T20:25:41Z

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

New page

<div style="font-size:30px">'''AVERAGEMIDDLE (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==

*AVERAGEMIDDLE([18,23,87,45,56,17,26,67,19,20],4) = 36

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

==See Also==

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

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

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

*[[ Z3 | Z3 home ]]

← Older revision		Revision as of 06:48, 10 August 2020
Line 5:		Line 5:
	**AVERAGE(), returns the average of its arguments.		**AVERAGE(), returns the average of its arguments.

−	~~==Description==~~

	*This function gives the Average for given set of numbers from the top.		*This function gives the Average for given set of numbers from the top.

← Older revision		Revision as of 09:17, 11 August 2020
Line 5:		Line 5:
	**AVERAGE(), returns the average of its arguments.		**AVERAGE(), returns the average of its arguments.

		+	==Description==

	*This function gives the Average for given set of numbers from the top.		*This function gives the Average for given set of numbers from the top.

Manuals/calci/AVERAGEMIDDLE - Revision history

Devika at 09:17, 11 August 2020

Devika at 06:48, 10 August 2020

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

Joseph: Created page with "
'''AVERAGEMIDDLE (Range,TopCount) '''

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