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

[Mihovil Stanic]

Done.
https://bugs.freedesktop.org/show_bug.cgi?id=67205

Dana 22.7.2013. 23:11, Sérgio Marques je napisao:



2013/7/22 Mihovil Stanic >


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.





--
To unsubscribe e-mail to: l10n+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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Sérgio Marques]

2013/7/22 Mihovil Stanic 

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

Returns the smallest value for which the
cumulative binomialdistribution is less than or equal to a criterion value.


To

Returns the smallest value for which the
cumulative binomialdistribution is greater than or equal to a criterion va
lue.


 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: l10n+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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Mihovil Stanic]

Thank you for help Brian and Regina.
Sergio, can you please open bug report then and CC Andras so he can fix it?

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 



--
To unsubscribe e-mail to: l10n+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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted