The AVEDEV function should return the average deviation of a list of values. However, the formula given for this function is actually for the calculation of the number of combinations of n things taken k at a time.

It is requested to place the correct formula for standard deviation

Part 4, Section 3.17.7.17

te

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