In statistics, there are four kinds of t-test statistics ( t-test ), namely:?

1. Test the hypothesis that the mean of the population is equal to a certain value
2. Test the hypothesis for the difference in the mean of two random samples with the same variance ( t-Test: Two-Sample Assuming Equal Variances )
3. Test the hypothesis for the difference in the mean of two random samples with unequal variances ( t-Test: Two-Sample Assuming Unequal Variances )
4. Test the hypothesis for the mean of the sample in paired observations ( t-Test: Paired Two Sample For Means )

The following is a two-way student t-test tutorial to compare two median values of a random sample (population) with unequal variances ( t-Test: Two-Sample Assuming Unequal Variances ) using the Add-Ins Analysis Toolpak Excel. This t-test assumes that the two data groups come from a distribution with heterogeneous variance.

You can learn more about Excel tutorial: t-test 2 heterogeneous variance populations in the following video.

Excel Tutorial: 2-population t-test of heterogeneous variance

Hipotesis t-Test: Two-Sample Assuming Unequal Variances (two tail):

H0 : µ1 = µ2
HA : µ1 ≠ µ2

Excel tutorial: 2 population t test of heterogeneous variance

You can learn a list of other Microsoft Excel Tutorials at the following link:

Tutorial Microsoft Excel

Excel Tutorial: 2-population t-test of heterogeneous variance