This section which specifies the behaviour of AVEDEV which is supposed to return the average of the absolute deviations of its arguments is completely wrong as the corresponding formula in the specifications is to calculate the number of combinations of “n” things taken “k” at a time which is completely different function.

 

3.17.7.17

te

Proposed Disposition of DIS 29500 Comment PH-0003 (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 26­27, 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 , MT-0004 , US-0276 , UY- 0010