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

2013/7/22 Mihovil Stanic <mihovil.stanic@gmail.com>

>  Thank you for help Brian and Regina.
> Sergio, can you please open bug report then and CC Andras so he can fix it?
I don´t have an bugzilla account. Can You do it? Or someone with an account
there.

What needs to be fixed is:


UI:

File: sc/source/ui/src.po
Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_KRIT_BINOM 1 string.text


     Comment:

o6CUv


Border arguments of the binomial distribution.

To:
 Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CRIT_BINOM 1 string.text
 Returns the smallest value for which the cumulative binomial distribution
is greater than or equal to a criterion value.

Help files:
 File:


scalc/01.po
Context:

04060183.xhp par_id3149254 49 help.text
Comment:


yXdFy


From:

<ahelp hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the
cumulative binomialdistribution is less than or equal to a criterion value.
</ahelp>

To

<ahelp hid="HID_FUNC_CRITBINOM">Returns the smallest value for which the
cumulative binomialdistribution is greater than or equal to a criterion va
lue.</ahelp>


 If someone could do it I would appreciate it.



http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM


 Regards





>  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


-- 
Sérgio Marques

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