<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - ANOVA uses wrong formula when on new sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121103#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - ANOVA uses wrong formula when on new sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121103">bug 121103</a>
from <span class="vcard"><a class="email" href="mailto:pnetmod@f2s.com" title="Libomark <pnetmod@f2s.com>"> <span class="fn">Libomark</span></a>
</span></b>
<pre>This should be a very easy fix for anyone who has worked on Scaddins: most of
the formulae produced by ANOVA are correct, so there is already a good template
for the two that need amending.
An alternative for the Total cell - Sheet2.C12 in the example file is to
replace
=DEVSQ($Sheet1.$B$1:$B$30,$Sheet1.$C$1:$C$30,$Sheet1.$D$1:$D$30)
with
=DEVSQ(($Sheet1.$B$1:$B$30),($Sheet1.$C$1:$C$30),($Sheet1.$D$1:$D$30))
only the extra brackets need inserting - the range and sheet references are
correct
although =SUM($Sheet2.$C$10:$C$11) is simpler as a calculation for the same
result
(In this context Sheet2=OutputSheet Sheet1=DataSheet)
Sondra has nailed the amendment needed to the "Withing groups" calculation -
refer to the data input sheet in the formula references, rather than omitting
it.</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>