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 pooled standard error? Refer to the following URL:
https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6
Please advise or provide feedback.
1 Reply
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.
