XMLWordPrintable

#### Details

• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: None
• Fix Version/s:
• Component/s:
• Labels:
None
• Proposal:
Hide

Change the description of TTEST as shown in the attachment to http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/201001/msg00088.html

As of draft draft22a:
For type=1 change
t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n -1}}
to
t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n }}

Show
Change the description of TTEST as shown in the attachment to http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/201001/msg00088.html As of draft draft22a: For type=1 change t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n -1}} to t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n }}
• Resolution:
Show
Change the description of TTEST as shown in the attachment to http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/201001/msg00088.html

#### Description

== 6.17.80 TTEST ==

A lot of problems
(1) All formulas miss the degrees of freedom. It is necessary for TDIST.
In case unequal variance there must be defined, whether the degrees of
freedom are made integer by FLOOR or whether they remain real.
(2) In case paired: sqrt

{n-1}

is wrong because it is already contained
in s_

{X_1 - X_2}

.
(3) In case equal variance: definition of sÂ² is missing.
(4) In case unequal variance: definition does not meet usual
definitions. In fact it is the definition for the equal variance case,
with pooled variance.
(5) As TDIST actually returns the values of the cumulative distribution
function, the definite integral in the formulas has to be revised
together with TDIST.

#### People

• Assignee:
Andreas Guelzow
Reporter:
Robert Weir (Inactive)
• Watchers:
0 Start watching this issue

#### Dates

• Created:
Updated:
Resolved: