Manuals/calci/AVERAGE

AVERAGE(n1,n2,n3)

• Where $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 $n$ numbers are given and each number is denoted by $ai$, where $i=1$ to $n$, then

$A.M={\frac {1}{n}}\sum _{i=1}^{n}ai$ = ${\frac {1}{n}}(a1+a2+.....+an)$.

• In this function $n1,n2,n3...$ can either be numbers,arrays,references of cells or we can enter the logical values directly.
• This function will show the result as Error,

1. when the values are error values or text that cannot change in to numbers.

• If the distribution is symmetric, we can use this function to find the central tendency.
• The three most common measures of central tendency are: A.M, Median,& Mode.A.M:
• It is calculating by adding the given set of numbers and divided by the count of the given set of numbers. *E.g: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.
• E.g: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.
• E.g.The mode of 2,2,2,3,4,5 and 7 is 2

$\sum _{k=1}^{N}k^{2}$

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