T Test Excel Example. One sample t test is used when we are in need of checking the mean of an individual group against an unknown mean. The degrees of freedom for the t test calculated as n 1 n 2 2 20 20 2 38.
To perform a t test execute the following steps. In excel the first and foremost thing we need is the installation of an add in called data analysis. μ 1 μ 2 0.
T test b2 b11 c2 c11 1 1.
For variable 1 range select the data to be tested in our example column b and for variable 2 range select the dummy column data. T test in excel example 2. The t test is used to test the null hypothesis that the means of two populations are equal. μ 1 μ 2 0.
