https://bugs.documentfoundation.org/show_bug.cgi?id=104899
Bug ID: 104899
Summary: Data Analysis T test error in formula for standard
error of the difference of sample means
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ejba...@gmail.com
Created attachment 129912
--> https://bugs.documentfoundation.org/attachment.cgi?id=129912&action=edit
The attached shows bug in Data Statistics T test
in Data Statistics T-test:
t statistic is currently computed using a formula like this:
=($Sheet3.$E$21 - $Sheet3.$E$15) / ($Sheet3.$E$22 / ( $Sheet3.$E$23 + 1)) ^ 0.5
This leads to p values that are approximately half the correct values.
The t statistic should use a formula like this:
=(F17-E17)/SQRT(E18/E19+F18/F19)
the terms in the square root are
s1^2/n1 + s2^2/n2
This correction leads to results which are comparable to the cell function
t.test
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs