Compare independent groups without pooling their variances
Enter separate formulas in G2:G9. A2:A21 and B2:B21 are independent groups; their lengths may differ and their row positions do not form pairs. D2 is alpha. Report each count, mean A minus mean B, its unequal-variance standard error, fractional Welch degrees of freedom, signed t for a zero population-mean difference, two-sided unequal-variance p, and the Boolean result p<=alpha. Use T.TEST tails=2/type=3; do not pool variances or round the displayed degrees of freedom.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter separate formulas in G2:G9. A2:A21 and B2:B21 are independent groups; their lengths may differ and their row positions do not form pairs. D2 is alpha. Report each count, mean A minus mean B, its unequal-variance standard error, fractional Welch degrees of freedom, signed t for a zero population-mean difference, two-sided unequal-variance p, and the Boolean result p<=alpha. Use T.TEST tails=2/type=3; do not pool variances or round the displayed degrees of freedom.
No account. No upload. Just try it.