![two sample unequal variance t test excel two sample unequal variance t test excel](https://i1.wp.com/statisticsbyjim.com/wp-content/uploads/2019/09/paired-t_output.png)
If the fourth assumption fails, then the more conservative unpooled estimated standard error is used (and the test is referred to as “Welch’s Test”). If the fourth assumption is met, then the pooled estimated standard error is used in the calculation of the test statistic. A two-sample test for means was conducted to test whether the mean number of movies watched each month differed between males and females.
![two sample unequal variance t test excel two sample unequal variance t test excel](https://spreadsheeto.com/wp-content/uploads/2019/09/t-test-function-formula.png)
![two sample unequal variance t test excel two sample unequal variance t test excel](https://image1.slideserve.com/2267815/two-sample-tests-in-excel-l.jpg)
If the third assumption is not met, the alternative test is the Mann-Whitney U-Test, which can be run to see if there is a difference between two groups for a variable with any type of distribution.