Using the Independent Samples T-Test Function
The independent samples t-test in EZAnalyze allows you to determine the statistical significance of a difference between two group means. Since this is an Advanced feature of EZAnalyze, it will not be discussed at length here. Feel free to consult a statistics textbook or the Internet for information on what an independent t-test is and how it works. If you are already familiar with independent samples t-tests and want EZAnalyze to crunch the numbers for you, read on!
To conduct this analysis, your data will need to have at least two variables - one dependent variable, and one categorical variable containing the groups you would like to test. NOTE - your categorical variable can have more than two groups - you select which specific groups you want to look at later.
To conduct an independent samples t-test, select "Advanced" from the EZAnalyze menu in Excel, then choose "T-Tests" and select "Independent samples".
In the "Independent Samples T-Test" dialog box, select a dependent variable in the left column under "Dependent variable" and an independent (grouping) variable in the middle column under "Categorical variable."
Once you have selected a categorical variable, you will see a list of all of the values contained in the categorical variable you selected. If you have two groups in your data, they are selected for you. Otherwise, select two of these values by clicking on each one once.
When you click OK, a results report will be printed on a separate sheet for your review. (click on "results report" for information on how to interpret this analysis)