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 …') |
(→type = 1) |
||
| Line 4: | Line 4: | ||
where Γ is the Gamma function. | where Γ is the Gamma function. | ||
| − | ==== type = 1 ==== | + | ==== Paired Samples ==== |
| + | If type=1, a paired Student's test is calculated. It uses the differences of the pairs. So in this case the data X and Y should have the same count n. | ||
| + | <math>\overline{X} = \frac{1}{n}\ \sum_{i=1}^n\, X_i</math> | ||
| + | <math>\overline{Y} = \frac{1}{n}\ \sum_{i=1}^n\, Y_i</math> | ||
| + | |||
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 | 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 | ||
| Line 10: | Line 14: | ||
TTEST returns. | TTEST returns. | ||
| + | |||
| + | ==== Unpaired Samples, Equal Variance ==== | ||
| + | |||
(2)If type = 2, TTEST calculates the p-value of a comparison of means for independent samples from populations with equal variance. With | (2)If type = 2, TTEST calculates the p-value of a comparison of means for independent samples from populations with equal variance. With | ||
| − | and | + | and |
| + | |||
| + | ==== Unpaired Samples, Not Necessarily Equal Variances | ||
TTEST returns . | TTEST returns . | ||
Revision as of 19:55, 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.
Paired Samples
If type=1, a paired Student's test is calculated. It uses the differences of the pairs. So in this case the data X and Y should have the same count n.
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.
Unpaired Samples, Equal Variance
(2)If type = 2, TTEST calculates the p-value of a comparison of means for independent samples from populations with equal variance. With
and
==== Unpaired Samples, Not Necessarily Equal Variances
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.
