Independent T Test Excel. In excel you can use f test two sample for variances to test the probability of equal. This value is the null hypothesis value.
The t test function in excel is designed to work on two independent sample sets. If tails 2 ttest uses the two tailed distribution. Type is the kind of t test to perform.
From the data analysis popup choose t test.
Click on data analysis under the data tab. In simple terms the result of the test indicates whether the difference is significant or due to random chance. Select the variable 1 range and variable 2 range. From the data analysis popup choose t test.
