[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 different. Andreas -- 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]