• Home
• Fundamentals
  Introduction What is statistics Terms connected to data Measurement levels Significance SPSS basics
• One variable
  Introduction a binary variable a nominal variable an ordinal variable a scale variable
• Two variables - unpaired
  Introduction binary vs binary binary vs ordinal binary vs scale nominal vs nominal nominal vs ordinal nominal vs scale ordinal vs ordinal ordinal vs scale scale vs scale
• Two variables - paired
  Introduction two nominal two ordinal two scale
• 3+ variables - paired
  Introduction 3+ binary 3+ ordinal 3+ scale
• Distributions
  Introduction Binomial Bivariate Normal Chi-Square (Standard) Normal Student t Wilcoxon (Signed Rank)
• Search

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.

The Analyze My Survey (AMS) Excel file is available here it (opens in new tab) (MD5 checksum: 3AB079345B001E93AC9AE315A86F9355)

The AMS SPSS data preparation file is available here (opens in new tab) (MD5 checksum: D7C1D74F6396362D0FB7A19332BD6C12).

Google adds