Difference between revisions of "Documentation/How Tos/Calc: AVEDEV function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(See also:)
m
 
(8 intermediate revisions by 5 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{DISPLAYTITLE:AVEDEV function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_Statistical_functions
 +
|NextPage=Documentation/How_Tos/Calc:_AVERAGE_function
 +
}}__NOTOC__
  
 
== AVEDEV ==
 
== AVEDEV ==
Line 16: Line 21:
 
: 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.
  
=== See also: ===
+
{{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]]
[[Documentation/How_Tos/Calc: STDEV function|'''STDEV''']],
+
* [[Documentation/How_Tos/Calc: STDEV function|STDEV]]
[[Documentation/How_Tos/Calc: VAR function|'''VAR''']]
+
* [[Documentation/How_Tos/Calc: VAR function|VAR]]
  
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
  
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Statistical functions]]

Latest revision as of 13:07, 2 February 2024



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 Calc avedev equation.png

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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_AVEDEV_function&oldid=260009"
Views
Personal tools
Navigation
Tools