2013/7/22 Mihovil Stanic <mihovil.sta...@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+unsubscr...@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
