2 Sample T Test Excel. Smith to determine which class has higher grades on an exam. Step i 1 2 t test.
Sample size n1 40 sample mean weight x1 300 step 2. If you don t have a dataset download the example dataset here. From the data analysis popup choose t test.
For variable 1 range select the sample 1 range column b and for variable 2 range select the sample 2 data column c while the hypothesized mean difference is 0.
Reader favorites from statology report this ad when we conduct. On the data tab in the analysis group click data analysis. Step i 1 2 t test. 2 5 after applying the t tests in excel the following tables are produced.
