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