Confidence function incorrectly assumes normal distribution, rather than specifying the type of distribution.
Correct function to incorporate specification of type of distribution
Part 4,Section 3.17.7.47
te
Proposed Disposition of DIS 29500 Comment AU-0027 (Modified: 2007-12-05) The CONFIDENCE function assumes a normal distribution, and this will be noted in Part 4, ยง3.17.7.47, page 2,571, line 30, as shown below. Certainly, other definitions of CONFIDENCE are possible; an implementation could define a new function to support additional distribution types. In the interest of backwards compatibility with the corpus of existing documents, it was decided to not modify the existing function to support alternate distribution types. 3.17.7.47 CONFIDENCE Syntax: CONFIDENCE ( alpha , standard-dev , size ) Description: Computes a value that can be used to construct a confidence interval for a population mean. The CONFIDENCE function assumes a normal distribution for calculation. Similar Comments: CL-0179 , CO-0171 , DK-0163 , ECMA-0026 , FR-0502 , GB-0383 , US-0182 , UY-0011
Dupe of Ecma 26