Forum Discussion
Analysis ToolPak
With respect to the Analysis ToolPak for use to perform the t-Test, if the option for "t-Test: Two-Sample Assuming Unequal Variances" is selected, is the Satterthwaite Approximation used and not the...
Yes — when you select “t-Test: Two-Sample Assuming Unequal Variances” in Excel’s Analysis ToolPak, Excel performs Welch’s t-test.
That means:
- It does not use a pooled standard error
- It uses separate sample variances
- The degrees of freedom are calculated using the Satterthwaite approximation (though Excel doesn’t explicitly name it)
So your understanding is correct.
My answers are voluntary and without guarantee!
Hope this will help you.