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
different.

Andreas

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