Statistical tests and tools

The MAX toolkit contains tools, step by step instructions and/or pre-recorded training presentations to support you to conduct a number of statistical tests in Excel. Additional guidance and suggestions on how to use these tools to explore your ASCS and PSS SACE datasets are provided in the further analysis guides [available on the downloads page].

Click on the links below to find out more and to access the tools and materials.

Please note: the full functionality of the MAX spreadsheet tools requires that you have Microsoft Excel 2010 or later, and that you have also installed the Analysis ToolPak and Real Statistics Resource Pack add-in programmes. Instructions on how to install these add-ins can be accessed here.

What do you want to do?Example research questionAnalysisToolInstructionsTutorialLink
 
Describe dataset (in other words, conduct descripives analysis)
Calculate more accurate estimates of service impact on quality of lifeWhat is the impact of our services on carer-reported quality of life?Adjustment calculations

X

Summarise and explore the relationship between two variablesDoes satisfaction vary between different groups of service users (e.g. characterised by age, ethnicity)?Cross tabulations

X

 
Establish whether there is a statistically significant association between:
two categorical variables Which of our service users are reporting unmet safety needs?Chi-square

X

the means of two unrelated groups Which of our carers are reporting difficulties in finding information?Independent t-test

NA

X

the means of two or more unrelated groupsAre service users with low SCRQOL also reporting poor outcomes in other areas?Analysis of variance (ANOVA)

NA

X

Back to: How to use MAX toolkit