Missing correlations in matrix PreviousNext
Mplus Discussion > Missing Data Modeling >
Message/Author
 Emily Sherman posted on Thursday, March 19, 2015 - 4:05 pm
I have a large correlation matrix in excel that has multiple missing values. First off, can you please clarify what type of file I need to put this in for Mplus to read it (I've read different things- .txt. prn, etc.) Secondly, what- if anything- do I need to put in the cells that are the missing values for it to be read? Do I need to use "correlation" for type in this case and is an ML estimator the best/necessary option?
 Bengt O. Muthen posted on Thursday, March 19, 2015 - 4:10 pm
Is it the correlation matrix that has missing correlations in it, or is it the raw data that has missing data for certain subjects on certain variables?
 Emily Sherman posted on Thursday, March 19, 2015 - 4:19 pm
It is the correlation matrix that has missing correlations in it. It is actually a correlation matrix of meta-analytically derived correlations wherein some correlations are not found in the literature.
 Bengt O. Muthen posted on Thursday, March 19, 2015 - 6:27 pm
What kind of model are you fitting to this correlation matrix?
 Emily Sherman posted on Friday, March 20, 2015 - 6:40 am
I'm hoping to fit multiple models, both EFA and CFAs. More so CFA's where I want to compare various models with 1-4 latent factors (regarding psychopathy) and also to correlate those latent factors with other factors regarding the five factor model of personality.
 Bengt O. Muthen posted on Friday, March 20, 2015 - 12:29 pm
I don't see how this can be handled. Unless the missing correlation values are in a certain pattern so the matrix can be broken up into groups with fewer variables per group.
 Emily Sherman posted on Friday, March 20, 2015 - 12:50 pm
As it is, I don't see a way to break up the matrix into smaller groupings, and I am aiming to do models that necessarily require all of the information. To clarify- is it required that if one wants to use a correlation matrix as the sole input nothing can be missing?

I've read other studies with the same problem that state- "Missing correlations were estimated with composite
maximum likelihood (ML) methods. In this approach, an exploratory factor model
was first fit to the available correlations of the matrix; this
model was used to generate model-predicted correlations,
which were used as imputed values for the missing correlations
in the matrix."

Is this not possible with Mplus?
 Bengt O. Muthen posted on Friday, March 20, 2015 - 1:25 pm
I don't know about this composite ML approach, but if it is sound I would think there is a way to do it in Mplus. Please send me an article on it.
 Emily Sherman posted on Friday, March 20, 2015 - 1:49 pm
This is the article in which I found the above quote- Sharma, L., Markon, K. E., & Clark, L. A. (2014). Toward a theory of distinct types of 'impulsive' behaviors: A meta-analysis of self-report and behavioral measures. Psychological Bulletin, 140(2), 374-408. doi:10.1037/a0034418.

The authors talk only briefly about the technique on pg. 379 in the paragraph that begins "This methodology resulted in a 58X58 correlation matrix..." (I have emailed the corresponding author of this article to clarify what program they used as well). There are a few other resources they cite that I have either not yet had access to (Markon, 2011; Lindsay, 1988) or am having trouble following because of the complexity (Cudeck, 2000).

Continuing thanks for your responses.
 Bengt O. Muthen posted on Friday, March 20, 2015 - 3:17 pm
what is the Cudeck, 2000 ref?
 Emily Sherman posted on Friday, March 20, 2015 - 3:27 pm
Cudek, R. (2000) An Estimate of the Covariance Between Variables Which are not Jointly Observed. Psychometrika, 65(4), 539-546.
 Bengt O. Muthen posted on Friday, March 20, 2015 - 4:08 pm
Will have a look at it.
Back to top
Add Your Message Here
Post:
Username: Posting Information:
This is a private posting area. Only registered users and moderators may post messages here.
Password:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: