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