Difference between revisions of "User:Regina/MYDrafts3"
((checkpoint save)) |
|||
Line 35: | Line 35: | ||
<math>{s_P}^2 = \frac {(n-1) {s_X}^2 + (m-1) {s_Y}^2} {n-1+m-1} </math> | <math>{s_P}^2 = \frac {(n-1) {s_X}^2 + (m-1) {s_Y}^2} {n-1+m-1} </math> | ||
− | + | and | |
<math>t = \frac {\left | \overline X - \overline Y \right |}{\sqrt { {s_P}^2(\frac 1 n + \frac 1 m)}}</math> | <math>t = \frac {\left | \overline X - \overline Y \right |}{\sqrt { {s_P}^2(\frac 1 n + \frac 1 m)}}</math> | ||
Line 42: | Line 42: | ||
− | ==== Unpaired Samples, Unequal Variances | + | ==== Unpaired Samples, Unequal Variances ==== |
If type = 3, TTEST calculates the p-value of a comparison of means for independent samples from populations with not necessarily equal variances. | If type = 3, TTEST calculates the p-value of a comparison of means for independent samples from populations with not necessarily equal variances. | ||
Line 54: | Line 54: | ||
TTEST returns <math>\, tails \cdot \int_t^\infty f(x,\nu) \, dx </math> . | TTEST returns <math>\, tails \cdot \int_t^\infty f(x,\nu) \, dx </math> . | ||
− | + | ||
OpenOffice.org uses internally the regularized incomplete beta function to calculate the integral. | OpenOffice.org uses internally the regularized incomplete beta function to calculate the integral. | ||
− | An empty element or an element of type ''string'' is ignored and in case paired samples its corresponding element in the other sample | + | An empty element or an element of type ''string'' is ignored and in case paired samples its corresponding element in the other sample too. In contrast to other spreadsheet applications OpenOffice.org has no type ''boolean'' but treats ''false'' as 0 and ''true'' as 1. |
Latest revision as of 22:35, 31 March 2010
Contents
Details
The Student's test is related to the t-distribution. Its density function is
where is the Gamma function and the parameter degree of freedom.
Paired Samples
If type=1, TTEST calculates the p-value for paired samples. It uses the differences of the pairs. So in this case the data X and Y should have the same count n.
TTEST returns
Unpaired Samples, Equal Variance
If type = 2, TTEST calculates the p-value of a comparison of means for independent samples from populations with equal variance. Besides
it uses the pooled variance
and
TTEST returns
Unpaired Samples, Unequal Variances
If type = 3, TTEST calculates the p-value of a comparison of means for independent samples from populations with not necessarily equal variances.
TTEST returns .
OpenOffice.org uses internally the regularized incomplete beta function to calculate the integral.
An empty element or an element of type string is ignored and in case paired samples its corresponding element in the other sample too. In contrast to other spreadsheet applications OpenOffice.org has no type boolean but treats false as 0 and true as 1.