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

Thank you for help Brian and Regina.
Sergio, can you please open bug report then and CC Andras so he can fix it?

Best regards,
Mihovil

Dana 22.7.2013. 17:21, Brian Barker je napisao:
> 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


Dana 22.7.2013. 18:08, Regina Henschel je napisao:
> Hi Mihovil,
>
> Mihovil Stanic schrieb:
> > Nice catch.
> > Oasis says it's "greater then"
> > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM 
>
> That is correct. Although in the help I would not use "is greater than 
> or equal to a criterion value" but "...  threshold probability" as it 
> is used in explanation of "Alpha".
>
> > MS Office says "less then" in function title description
> > http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx?CTT=1 
>
> Wrong.
>
> > and then it says "greater then" in function description
> > http://office.microsoft.com/en-us/excel-help/critbinom-function-HA102753199.aspx?CTT=5&origin=HA102752955 
>
> Correct.
>
> > LO says "less then".
> > Would be nice if someone could actually use this formula and say which
> > is true. :)
>
> Wrong.
>
> Kind regards
> Regina 


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