Analyze My Survey
Prior to your survey, you should already know roughly which tests you want to perform with which variables. Very often I get the request if there is a way to perform all tests in one time with SPSS, R or Excel, and unfortunately there isn't.
For those who want to still perform all tests I've created a small Excel program (using macros) that can do the following:
1) Perform a univariate test on all variables
2) Perform unpaired tests on all possible combinations of two variables
3) Perform paired tests on all possible combinations of two variables
A few WARNINGS:
a) Peforming all these test is usually not necessary, and frowned upon especially in the academic field. Check with your supervisor if this is okay to be used.
b) Depending on the amount of cases and variables it can take quite some time before the results are done.
c) After performing the tests you would probably still need to analyze the results you find interesting further, there are for example no post-hoc tests calculated.
d) The program is in concept stage, so there might still be some errors in it. Use at own risk.
If you decide on using the program, I'd recommend running the univariate statistics first, it takes the least amount of time and if the data isn't prepared properly it will already be spotted with this. Please read the info page carefully on how to prepare your data. For SPSS data there is a separate file that can help prepare your data.
Before downloading, please watch the introduction video. Click here to see the video.
The Analyze My Survey (AMS) Excel file is available here it (opens in new tab) (MD5 checksum: 3AB079345B001E93AC9AE315A86F9355)
For the SPSS data preparation watch the introduction video first. Click here to see the video.
The AMS SPSS data preparation file is available here (opens in new tab) (MD5 checksum: D7C1D74F6396362D0FB7A19332BD6C12).