Manuals/calci/AVERAGEMIDDLE
AVERAGEMIDDLE (Range,TopCount)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Range} can be any set of real numbers.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} numbers are given and each number is denoted by Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle a_i} , where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle i=1} to Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} , then
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle A.M=\frac{1}{n}\sum_{i=1}^n a_i} = Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \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,
- 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
See Also
References