Difference between revisions of "Manuals/calci/AVERAGE"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
<math>A.M=\frac{1}{n}\sum_{i=1}^n ai</math> = <math>\frac{1}{n}(a1+a2+.....+an)</math>. | <math>A.M=\frac{1}{n}\sum_{i=1}^n ai</math> = <math>\frac{1}{n}(a1+a2+.....+an)</math>. | ||
*In this function <math>n1,n2,n3...</math> can either be numbers,arrays,references of cells or we can enter the logical values directly. | *In this function <math>n1,n2,n3...</math> 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. |
| − | *The | ||
*A.M is calculated by adding the given set of numbers and divided by the count of the given set of numbers. | *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 | Average of 2,4,2,7,2,3 and 5 is 3.6 | ||
| Line 18: | Line 17: | ||
The median of 2,2,2,3,4,5,7 is 3 | 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. | *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 | + | 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== | ==Examples== | ||
Revision as of 05:01, 21 April 2014
AVERAGE(n1,n2,n3)
- Where are any real numbers.
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 numbers are given and each number is denoted by , where to , then
numbers are given and each number is denoted by 
, where 
to = .
= 
.
- In this function 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
- AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47)=19.125
- AVERAGE(5,-2,7,8,11,20,25,-9)=8.125
See Also