EXCEL spreadsheet for polychoric correlation computation

This spreadsheet may be used to evaluate polychoric correlations. The raw data with upto four categories per variable (coded 1 to 4) is entered in sheet one for upto 15 variables and a data set having upto 800 points. Polychoric correlations are then outputted in sheet 2. Note: for skewed variables leading to the possible non-occurrence of category combinations for variable pairs the estimation may not be possible and #VALUE will be returned. Other options for estimating polychorics are available which may handle more substantial skew than this spreadsheet.

One advantage of using a spreadsheet to compute polychoric correlations is that the correlation matrinx in sheet 2 may be copied and pasted into a SPSS spreadsheet and inputted for an exploratory factor analysis. See the Factor Analysis Graduate Talk 2009 for an example of how to do this.

Anecdotal evidence suggests Pearson correlations can be used for factor analysis is the variables have five or more categories and are approximately have a Normal distribution. The R 'hetcor' routine for estimating Polychoric correlations may also be installed into SPSS version 17 and above (see here.)