Difference between revisions of "User:Regina/MYDrafts3"
(Created page with '=== Details === Semantics: Let X1, X2, …,Xn be the numbers in the sequence X and Y1, Y2, …,Ym be the numbers in the sequence Y. Then and . Moreover let , and where Γ is …') |
(No difference)
|
Revision as of 18:57, 31 March 2010
Details
Semantics: Let X1, X2, …,Xn be the numbers in the sequence X and Y1, Y2, …,Ym be the numbers in the sequence Y. Then and . Moreover let , and
where Γ is the Gamma function.
type = 1
TTEST calculates the p-value for a paired-sample comparison of means test. Note that in this case due to the above constraints n=m. With
and
TTEST returns. (2)If type = 2, TTEST calculates the p-value of a comparison of means for independent samples from populations with equal variance. With
and
TTEST returns . (3)If type = 3, TTEST calculates the p-value of a comparison of means for independent samples from populations with not necessarily equal variances. With
and
TTEST returns . For an empty element or an element of type Text or Boolean in X the element at the corresponding position of Y is ignored, and vice versa.