Manuals/calci/AVERAGEMIDDLE

AVERAGEMIDDLE (Range,TopCount)

• $Range$can be any set of real numbers.
• $TopCount$ 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 $n$ numbers are given and each number is denoted by $a_{i}$, where $i=1$ to $n$, then

$A.M={\frac {1}{n}}\sum _{i=1}^{n}a_{i}$ = ${\frac {1}{n}}(a_{1}+a_{2}+.....+a_{n})$.

• 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,

1. 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

Average

See Also

• AVERAGE
• AVERAGEBOTTOM
• AVERAGETOP
• AVERAGEA

References

Average

• List of Main Z Functions

• Z3 home