Help needed Pearsons R table for Categorical Independent variables

[Boris Cornelis]

Hi All,

I am trying to create a Pearson's correlation table in Stata.
The experiment looks at Independent variable (respondents being randomised between 3 manipulations) = none, negative none-verbal cues, and positive none-verbal cues.
Dependent variable looks into investing decision and attitudes.

Atm I have my stata sheet cleaned (with all the way on the left column with string variables Cues = with under neath all the negative, positive, none responses) = see foto

Now i want to compare quite a few variables within the Pearsons's table. How can I do this though given the categorical IV situation?

[Maarten Buis]

Brief answer: You cannot.

Correlation just does not make sense in your case. Longer answer you probably want a cross-tabulation if the other variable is also categorical or table of means

[Boris Cornelis]

Yes so all 3 conditions = categorical (positive, negative, none)
Only thing is with a cross tabulation can I display correlations?

[Maarten Buis]

You can do anything you want, question is does it make sense. So what variables do you want to correlate with one another?

[Boris Cornelis]

What I want to do is create an overview pearsons correlation table for the main variables within my experiment, that also includes variables, age, gender, employment etc
However Seeing as my caterigorical IV complicates things (with its none binary values) I cannot simply make dummy values and run a pearsons correlation table.
Atleast I don't think this is possible.

Hence I am quite unsure how I am able to do this

[Maarten Buis]

Correlation is just one of many measures of association. It looks like you need to find another. The key is not to over think it: if you want to know the bivariate association between gender and income, then you can report the mean wage of women and the mean wage of men... Simple is better for such a descriptive table.

[Nick Cox]

See also another thread started today with a similar question https://www.statalist.org/forums/for...continuous-one