Manuals/calci/AVERAGE

AVERAGE(n_1,n_2,n_3,....)

• 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 n1,n2,n3...} are any real numbers.

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 ai} , where $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 ai} = 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}(a1+a2+.....+an)} .

• In this function 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 n1,n2,n3...} 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

• AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47)=19.125

• AVERAGE(5,-2,7,8,11,20,25,-9)=8.125

See Also

• AVEDEV
• AVERAGEA

References

Average