<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - LibreOffice.calc data|statistics|z-test repeated results" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132983#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - LibreOffice.calc data|statistics|z-test repeated results" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132983">bug 132983</a> from <a class="email" href="mailto:felipeviggiano@gmail.com" title="Felipe Viggiano <felipeviggiano@gmail.com>"> Felipe Viggiano</a> <pre>(In reply to Buovjaga from <a href="show_bug.cgi?id=132983#c5">comment #5</a>) > By this proposal, do you mean that additional fields should be added into > the dialog like exist in Excel: > <a href="https://www.dummies.com/software/microsoft-office/excel/how-to-perform-z">https://www.dummies.com/software/microsoft-office/excel/how-to-perform-z</a>- > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>