CONFIDENCE function needs some more information Make it clear that this assumed a Normal distribution
Proposed Disposition of DIS 29500 Comment DK-0163 (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: AU-0027 , CL-0179 , CO-0171 , ECMA-0026 , FR-0502 , GB-0383 , US-0182 , UY-0011

Tag and Go

No Comments

Sorry, the comment form is closed at this time.

  • Argentina (1)
  • Australia (30)
  • Austria (1)
  • Belgium (1)
  • Brazil (64)
  • Bulgaria (3)
  • Canada (79)
  • Chile (217)
  • China (1)
  • Colombia (237)
  • Czech Republic (75)
  • Denmark (168)
  • Ecma (76)
  • Ecuador (1)
  • Finland (15)
  • France (592)
  • Germany (162)
  • Ghana (12)
  • Greece (113)
  • India (82)
  • Iran (58)
  • Ireland (12)
  • Israel (33)
  • Italy (2)
  • Japan (82)
  • Jordan (1)
  • Kenya (81)
  • Malaysia (23)
  • Malta (5)
  • Mexico (7)
  • New Zealand (54)
  • Norway (12)
  • Peru (10)
  • Philippines (7)
  • Poland (4)
  • Portugal (118)
  • Singapore (2)
  • South Africa (17)
  • South Korea (25)
  • Spain (1)
  • Switzerland (19)
  • Thailand (1)
  • Tunisia (3)
  • Turkey (1)
  • UK (635)
  • Uruguay (18)
  • USA (288)
  • Venezuela (73)