How do I get a correlation color map with categorical and numeric variables?

DBM_860752 — Mon, 12 May 2025 13:06:23 GMT

About correlation maps, I see that in the multivariate, the correlation map accepts only numeric variables and the range for correlation coefficients is between -1 and 1. In the DOE module, I can evaluate a DOE test matrix with a correlation map that accepts all factors, including categorical, and the range for the correlation coefficients is between 0 and 1. I would like to use the second type of correlation but I do not need to perform any DOE. Is this second type of correlation map available outside the DOE module to make correlation analysis of data from experiments with numeric and categorical variables/factors?

Re: How do I get a correlation color map with categorical and numeric variables?

Jed_Campbell — Mon, 12 May 2025 14:17:00 GMT

If you select the categorical factors you'd like to use, then use the Cols > Utilities > Labels to Codes tool, you can assign numeric values to categories. Then, you can use the Analyze > Multivariate Methods > Multivariate platform to ask for a Color Map on Correlations. Example below and file attached.

Note: I added the 2-way interactions and squared terms using column formulas in the platform launch window.

topic How do I get a correlation color map with categorical and numeric variables? in Discussions

How do I get a correlation color map with categorical and numeric variables?

Re: How do I get a correlation color map with categorical and numeric variables?