138
views
views

Through, T-test in Excel you can decide the statistical significant differences between the datasets. In order words, it is a two-sample T-test which compare the means of two samples.
Perform a T Test in Excel - Now, you should choose F-Test Two-Sample for Variances from the list and then tap on OK button. Here, you need to choose the Variable 1 Range and Variable 2 Range and then you need to set the Alpha. At this point, you need to choose a cell for the top left side of the output and it will fill 3 columns and 10 rows and then tap on OK button. You should view the F-Test results to check if there is a significant difference between the variances.