I would like to perform correspondence analysis, but please let me know what processing I should do before stacking columns.When I did a correspondence analysis, I stacked the data in columns, and in the analysis, I changed the ID: title to scale = explanatory variable, label = objective variable, and data = frequency, but it says ``All columns''. "Cannot be analyzed because it is 0." appears.
Please tell me what I should do to correct the data.
Data Blending and CleanupRe: I want to do a correspondence analysis, please tell me what to do before stacking columns.Which menu are you running the correspondence analysis from?
For example, in the case of "Analysis" > "Bivariate relationship", it can be executed with the data and procedure described in the following manual.
https://www.jmp.com/support/help/en/16.2/#page/jmp/example-of-correspondence-analysis.shtml#ww448164
Also, fictitious data is fine, so I think it would be easier for other people to answer if you could tell us in more detail what kind of data format you are trying to analyze (sample data is attached) , attach screenshots, etc.).
For reference, I am attaching an example of the data for doing the correspondence analysis.