OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] LEGACY.CHIDIST and LEGACY.CHIINV:remove LEGACY prefix

On Mon, 2007-12-03 at 19:21 +0100, Eike Rathke wrote:
> Hi Andreas,
> On Friday, 2007-03-09 14:37:07 -0700, Andreas J. Guelzow wrote:
> > > We have prefixed LEGACY.CHIDIST and LEGACY.CHIINV, I don't think that is
> > > appropriate. We also don't have superior functions replacing them.
> > > I propose to remove the prefix from those two functions.
> > 
> > We have CHISQDIST and CHISQINV. The distribution is called the
> > chi-square distribution, not the chi distribution.
> But CHISQDIST would not calculate what CHIDIST did (right-tail
> probability), and CHISQINV not what CHIINV did, compare their
> mathematical formulas given in the spec.

All the other functions called ..DIST calculate density or cumulative
distribution. CHIDIST is the odd one out calculating 1 minus the
cumulative distribution.

It is quite dangerous to have a function that appears to be named to
match all those other distribution functions but calculates something


Andreas J. Guelzow, Professor
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]