Difference between revisions of "Manuals/calci/AVERAGE"

Revision as of 15:12, 7 August 2018

AVERAGE()

Parameters are any set of real numbers.
- AVERAGE(), returns the average of its arguments.

Description

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

ZOS

The syntax is to calculate AVERAGE in ZOS is 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 AVERAGE()} .
- Parameters are any set of real numbers.
For e.g.,AVERAGE(10..15..0.25)
AVERAGE(-10..-1)