Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.