0
$\begingroup$

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!

$\endgroup$

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.