[Libreoffice-bugs] [Bug 132983] LibreOffice.calc data|statistics|z-test repeated results

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132983

--- Comment #6 from Felipe Viggiano <felipeviggiano at gmail.com> ---
(In reply to Buovjaga from comment #5)

> By this proposal, do you mean that additional fields should be added into
> the dialog like exist in Excel:
> https://www.dummies.com/software/microsoft-office/excel/how-to-perform-z-
> test-calculations-in-excel/
> 
> Or do you mean something else?

Actually I was thinkking in simply insert the variance caculation in the ¨Known
variance¨ cells on the results table, instead of setting it to zero. This is
already done in the F-test function.
(core/sc/source/ui/StatisticsDialogs/FTestDialog.cxx --> lines 88 to 97) I have
uploaded some images of the F-test and the Z-test results. Note the the
variance id calculate on the F-test but in the Z-test it is set to zero.


But, if a change in the dialog could be done, that would be even better.
In this case, I would suggest inserting a condition where Calc calculate the
variance from the data given if the user keep a null value in the known
variance fields.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200905/7c270000/attachment.htm>