Re: [office-formula] List of functions in OpenFormula, dealingwith LEGACY.*

From
David A. Wheeler <>
Date
2008-06-13T18:21:05+00:00
ID
Thread
Re: [office-formula] List of functions in OpenFormula, dealingwith LEGACY.*
In summary, I'd like to do this:

Rename:
LEGACY.CHIDIST => CHISQDISTRIGHT
  since this is well-defined and useful (no need to eliminate)
LEGACY.NORMSDIST => NORMSDIST
  where NORMSDIST(x) = NORMDIST(x;0;1;TRUE())
  since this is also well-defined and useful

Make NORMDIST have defaults:
 Number Mean = 0; Number StandardDeviation = 1; Logical Cumulative = TRUE()

Make other DIST functions have default Cumulative = TRUE(), for ease of use.

Do similar operations for NORMSINV, NORMINV.

LEGACY.CHITEST unchanged; maybe we can get more info on it.

Okay?  Objections?


--- David A. Wheeler