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!