I created a table of Spearmans correlation for the continuous Likert scale motivations - which was great. I have compared them against each other (I believe this is correct?), as it was displayed on a table/matrix.

Secondly, I have categorical motivation data derived from a question "rate your top 3 motivations out of a list of 11", and derived multiple motivations from open-ended questions (coded into SPSS as categorical). The categorical data is has created is that respondents have either said 1- yes, or 2-no to each of the motivations (e.g. travel for health: 2-no (if they did not select it as their top 3).

I am trying to recreate the Spearman table, which easily correlated all of the motivations on one table. I have done it with Pearsons but have since realised this may not be correct? (A lot of them are negatively correlated).

It is somewhat possible to do it with a chi-squared but it creates A LOT of tables. Although, I have a group of 4 questions (what do you learn?: culture/history/nature/wellbeing). I can only put those questions into 1 axis on the chi-squared, when I want to correlate all 4 of them, like a correlation matrix that the Spearman table creates.

So therefore, I want to correlate my categorical data with all the other categorical data. I additionally want to correlate the continuous (Likert scale) with the categorical motivations / open-ended questions.

What tests do I use please? I have been googling it but other studies are different and I can't work out how to correlate all of them together to create a matrix, or if my Chi-square is correct. One similar answer said you have to use the eta?

Thanks in advance for the help!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.