Independent t-tests are a type of inferential statistic that can be used to determine whether there is a statistically significant difference between the means of two unrelated groups (e.g. men and women) on the same continuous dependent variable (e.g. SCRQoL). Independent t-tests are useful for exploring the differences between respondent groups and can be conducted in Excel.
The following pre-recorded presentation provides a demonstration of how you can conduct a independent t-test and the non-parametric equivalent (the Mann Whitney U Test) in Excel. Step-by-step instructions are also provided along with some ‘dummy’ practice data. Please note: the presentation and instructions are based on ASCS data but are also relevant to PSS SACE data.
Independent t-tests [step by step instructions] [dummy data]
Independent t-tests can be conducted in Excel. Please note: you will need to install the Analysis ToolPak and Real Statistics Resource Pack add-in programmes. Instructions on how to install these add-ins can be accessed here.
Back to: Statistical tests and tools page