https://bugs.documentfoundation.org/show_bug.cgi?id=121103
--- Comment #4 from Libomark <[email protected]> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
