Difference between revisions of "Documentation/How Tos/Calc: AVEDEV function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
Line 115: | Line 115: | ||
: returns <tt>'''2'''</tt>. The mean is <tt>'''4'''</tt>, and the absolute deviations from the mean are <tt>'''3'''</tt>, <tt>'''0'''</tt>, <tt>'''3'''</tt> respectively. | : returns <tt>'''2'''</tt>. The mean is <tt>'''4'''</tt>, and the absolute deviations from the mean are <tt>'''3'''</tt>, <tt>'''0'''</tt>, <tt>'''3'''</tt> respectively. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]] | * [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]] | ||
* [[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]] | * [[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]] |
Latest revision as of 07:58, 17 July 2018
CALC FUNCTIONS
Measures of Central Tendency
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Array Function category); GROWTH, LINEST, LOGEST, TREND
Ranking
AVEDEV
Returns the average of the absolute deviations of values from their mean.
Syntax:
AVEDEV(number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges containing numbers.
- AVEDEV calculates the mean of the numbers, then the absolute (positive signed) deviation of each number from that mean. It returns the average of those deviations. The formula used is
Example:
AVEDEV(1; 4; 7)
- returns 2. The mean is 4, and the absolute deviations from the mean are 3, 0, 3 respectively.
See Also