https://bugs.documentfoundation.org/show_bug.cgi?id=172643
Bug ID: 172643
Summary: Misleading explanation in help string in BINOMDIST
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Perhaps this is within your field? The LO Help string with code SmUaa currently
says:
<item type="input">=BINOMDIST(A1;12;0.5;0)</item> shows (if the values <item
type="input">0</item> to <item type="input">12</item> are entered in A1) the
probabilities for 12 flips of a coin that <emph>Heads</emph> will come up
exactly the number of times entered in A1.
IMHO, the phrase
"if the values 0 to 12 are entered in A1"
is misleading / not very good. The meaning is not at a string of numbers (or
non-integer numbers) should be entered into A1, but that one of the values 0,
1, 2, …, 12 should be entered in A1,. I suggest this reformulation:
"if an integer value from 0 to 12 is entered in A1" (and “probability” in
singular)
This corresponds to this full string
<item type="input">=BINOMDIST(A1;12;0.5;0)</item> shows (if an integer value
from <item type="input">0</item> to <item type="input">12</item> is entered in
A1) the probability for 12 flips of a coin that <emph>Heads</emph> will come up
exactly the number of times entered in A1.
Perhaps even better, the sentence should be reordered, e.g.
If an integer value from <item type="input">0</item> to <item
type="input">12</item> is entered in A1, then the formula <item
type="input">=BINOMDIST(A1;12;0.5;0)</item> shows the probability for 12 flips
of a coin that <emph>Heads</emph> will come up exactly the number of times
entered in A1.
Do you agree? If yes, is this something you could fix?
--
You are receiving this mail because:
You are the assignee for the bug.
