<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:felipeviggiano@gmail.com" title="Felipe Viggiano <felipeviggiano@gmail.com>"> <span class="fn">Felipe Viggiano</span></a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - LibreOffice.calc data|statistics|z-test repeated results"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132983">bug 132983</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - LibreOffice.calc data|statistics|z-test repeated results"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132983#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - LibreOffice.calc data|statistics|z-test repeated results"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132983">bug 132983</a>
from <span class="vcard"><a class="email" href="mailto:felipeviggiano@gmail.com" title="Felipe Viggiano <felipeviggiano@gmail.com>"> <span class="fn">Felipe Viggiano</span></a>
</span></b>
<pre>Doing a little research on google and found this website doing some explanation
about Z-Test:
<a href="https://www.solver.com/z-test-two-sample-means">https://www.solver.com/z-test-two-sample-means</a>
When running the example in Calc and manually inserting the variances in the
cells of the Z-Test results, the output was identical to the example on the
website.
So, the known variance should not be zero, and Calc should be able to calculate
it from the data given in the dialog.
I' not a developer myself (just starting to learn), but looking in the codes
(core/sc/source/ui/StatisticsDialogs/ZTestDialog.cxx), and it appears that the
Know Variance values are set to zero:
// Known Variance
aOutput.writeString(ScResId(STR_ZTEST_KNOWN_VARIANCE));
aOutput.nextColumn();
aOutput.writeValue(0); <------
aTemplate.autoReplaceAddress("%KNOWN_VARIANCE_VARIABLE1%",
aOutput.current());
aOutput.nextColumn();
aOutput.writeValue(0); <------
aTemplate.autoReplaceAddress("%KNOWN_VARIANCE_VARIABLE2%",
aOutput.current());
aOutput.newLine();
Perhaps if the output was changed to something like:
aTemplate.setTemplate("=VAR(%VARIABLE1_RANGE%)");
aTemplate.autoReplaceAddress("%VAR_VARIABLE1%", aOutput.current());
aOutput.writeFormula(aTemplate.getTemplate());
and
aTemplate.setTemplate("=VAR(%VARIABLE2_RANGE%)");
aTemplate.autoReplaceAddress("%VAR_VARIABLE2%", aOutput.current());
aOutput.writeFormula(aTemplate.getTemplate());
I believe this could remove the #DIV/0! error.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>