Re: [libreoffice-users] CRITBINOM function description is wrong

At 14:18 22/07/2013 +0100, Tom Davies wrote:
> From: Mihovil Stanic:
> > Dana 22.7.2013. 1:44, Sérgio Marques je napisao:
> > > File: scalc/01.po
> > > Context: 04060183.xhp par_id3149254 49 help.txt
> > > Comments: yXdFy
> > > <ahelp hid="HID_FUNC_KRITBINOM">Returns the 
> > > smallest value for which the cumulative 
> > > binomial distribution is less than or equal to a criterion value.</ahelp>
> > > Should be:
> > > <ahelp hid="HID_FUNC_CRITBINOM">Returns the 
> > > smallest value for which the cumulative 
> > > binomial distribution is greater than or equal to a criterion value.</ahelp>
> > >
> > > Also in:
> > > File: sc/source/ui/src.po
> > > Context:
> > > scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_KRIT_BINOM 1 string.text
> > > Comments: o6CUv
> > > Should be:
> > > Context:
> > > scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CRIT_BINOM 1 string.text
> >
> > Nice catch.
> > Oasis says it's "greater then"
> > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM
> >
> > MS Office says "less than" in function title description
> > http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx?CTT=1
> >
> > and then it says "greater than" in function description
> > http://office.microsoft.com/en-us/excel-help/critbinom-function-HA102753199.aspx?CTT=5&origin=HA102752955
> >
> > LO says "less than".
> > Would be nice if someone could actually use 
> > this formula and say which is true. :)
>
> If anyone could try out this weird function and 
> let us know what the results are then the 
> documentation and translators teams might be 
> able to describe it correctly.  So far  Oasis 
> doesn't seem to know what it does and MS can't 
> decide what their equivalent function does either!

It hardly necessary to do any testing: cumulative 
probability distributions start at zero and 
finish at one.  Zero is always going to be less 
than any criterion value, so any result is going 
to correspond to the start of the distribution 
and be trivial.  The original correspondent must 
be right: "greater than" is surely correct?

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted