Correspondence analysis is a technique that summarizes the patterns in a table of data as a visualization. Tables with multiple rows and columns can become difficult to read and identify patterns in the data. Correspondence analysis makes it easier to see the story in your data.
This article describes how to go from a data table containing multiple rows and columns:
To a correspondence analysis output in which you can better visualization the patterns in the data:
A table with multiple rows and columns containing data that are all on the same scale. This includes crosstabs showing counts, percentages, or averages, grids of data created from binary variables, and even raw numeric data.
- Open the document in Q containing the data set that you want to use to create the correspondence analysis.
- Create a table that you want to use as an input to the correspondence analysis. For this example, we'll use the table shown above which represents device ownership among different income groups.
- Select Create > Dimension Reduction > Dimension Reduction > Correspondence Analysis of a Table.
- From the object inspector on the right, select your table from the Input table(s) drop-down box.
- OPTIONAL: Remove any additional rows which correspond to 'NET' or 'Total' by adding the corresponding row/column labels in the Rows to ignore and Columns to ignore options. These should typically not be included in the analysis, and Displayr automatically removes 'NET', 'Total', and 'SUM' by default.
- OPTIONAL: Customize your title, colors, fonts, and gridlines using the settings under Chart.
- Click the Calculate button to generate the correspondence analysis output which will appear as a scatterplot on your page.
- OPTIONAL: Instead of a scatterplot, you can create a Moonplot visualization by selecting 'Moonplot' from the Output drop-down box in the object inspector.