Thanks! That was my gut feeling.
So the immediate action would be to change the screenshots in Help and
Calc guide so the variance cells have non-zero values, also adding a
note to the instructions.
A further question is, should we consider adding fields for inputting
variance values into the Z-test tool itself? Looking at Microsoft Office
docs, Excel has these. This would become an enhancement request in Bugzilla.
Ilmari
Mark Morin kirjoitti 2.9.2020 klo 2.57:
Variance can't be zero for analysis of variance tests (t test, F test,
etc). Statistical testing assumes that you have variance otherwise you
really wouldn't need a test.
On 9/1/2020 4:48 PM, Ilmari Lauhakangas wrote:
I was looking at a bug report again:
https://bugs.documentfoundation.org/show_bug.cgi?id=132983
The reporter is scratching their head over the "division by zero"
result for z.
From what I can see, the "Known variance" values can't both be zero,
if you want to avoid the #DIV/0! results. You have to give at least
one of them a positive non-zero value.
Now, looking at Help:
https://help.libreoffice.org/7.1/en-US/text/scalc/01/statistics_test_z.html
and the Calc guide chapter CG7009-DataAnalysis-SF-12Aug2020, we see
this same "division by zero" result and the reader is left holding it.
How to present this better in the docs? I have no experience on the
topic, but I hope we can find some statistician to shed light on this!
Ilmari
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy
