I have a dataset from social sciences that contains many ordinal categorical variables with > 2 levels which are linked to scores like 1 2 3..
I was asked if there are correlations between these ordinal variables so question: how to carry out correlation and PCA/Factor Analysis with this kind of data? Thanks for help!
Correlations are for continuous variables. Associations are for categorical variables.
I suggest that you try Multiple Correspondence Analysis. See the chapters in the Help > JMP Documentation Library > Multivariate Methods guide.
Marc, thanks for input this multiple correspondence analysis works fine for categorical data!
I also have data that are discrete numeric such as 1 2 4 5 . Is it possible to carry out a reliable PCA/factor analysis on such data i.e. will factor analysis give a correct grouping of the correlated discrete effects? Is it not better to use the spearman correlation approach?
No, PCA or factor analysis are not appropriate to analyze your ordinal data. The values are not numeric. They are just labels. They could be "A" through "E". You wouldn't use PCA or factor analysis with "A" through "E", right?
Ok if odinal hower numbers can also be counts or scores
You can have counts of discrete levels. Are the variables categorical? Are you counting these levels? It is still categorical data analysis.
Think there is a misunderstanding related to the title of my dicussion referring to ordinal data; this can be handled with multiple correspondence.
However on top of ordinal variables my data set also contains many factors that are discrete numeric like counts (#defects) and scores (ratings 1 - 5) so my question is if factor analysis for these discrete numeric variables is possible in order to find the underlying correlation structure? I am confused about correlation between these discrete variables: when I make a mulltivariate plot correlations look terrible.. on the other hand when I loo to the color map many re& pink spots appear indicating correlation? How to correctly analyse these discrete factors?
Thanks for article on MCA, how about Latent Class Analyis; is this an equivalent approach for classifying ordinal variables?
LCA clusters rows based on frequency. Latent semantic analysis clusters levels (variables).