For the function AVEDEV (average deviation), the formula given is incorrect and does not give the average deviation.
The correct formula should be included.
Part 4, Section 3.17.7.17
ed
Proposed Disposition of DIS 29500 Comment MT-0004 (Modified: 2008-01-13) Yes, the formula for this SpreadsheetML function is incorrect. In Part 4, §3.17.7.17, page 2,545, line numbers 2627, it will be changed from The number of combinations is as follows, where number = n and number-chosen = k: to The average of the absolute deviations of a set of data points from their mean is as follows, where n is the number of arguments in argument-list, x is an argument in argument-list, and x-bar is the x mean value: 1 - Similar Comments: AU-0026 , CA-0070 , CL-0024 , CO-0165 , DK-0162 , ECMA-0025 , FR-0466 , GB-0378 , PH-0003 , US-0276 , UY- 0010
Dupe of Ecma 25