This function goes through the selected tables and outputs and creates a new page with details about the tables that have the most interesting results.
Method
- Select multiple outputs at once or select them at the folder level in the Pages tree.
- Go to any of the following menu options:
- Anything > Report > Identify Interesting Tables
- Table > Report > Identify Interesting Tables
- A new page will be inserted in the Pages tree labeled "Most Interesting Results" with details of which input tables have been identified as interesting results.
A heatmap (for crosstabs) or bar (for summary tables) visualization will additionally be created to highlight the interesting results automatically as well where the areas with the darkest fill correspond with the tables that have the highest scores as described above.
Technical Details
- The table output contains one row for each of the questions featured among the rows of the selected tables, and one column for each of the questions featured among the columns of the selected tables. Each cell contains a score from 0 to 5 indicating the z-Statistic of the most significant result shown on the table for those two questions, with higher scores indicating that the table contains a more interesting result, and lower scores indicating that the table does not contain any interesting results.
- For each table, the script identifies the z-Statistic with the largest magnitude (absolute value) and caps this value at 5. The z-Statistics on a table can be checked by selecting Statistics - Cells > z - Statistic. The z-Statistics are used by Displayr's statistical testing to indicate the lengths of arrows shown in cells of the table. Where cells are determined to be significant, the largest Z will correspond to the cell with the largest arrow.
- The underlying table that is produced by this script is created with an R calculation whereby the results are static and not linked to the underlying data. They are determined at the time the script runs, and they will not update if the data changes. If you update your project with new data, or change the structure of the variables in your project, then you should run this script again to get an updated reading of the results.
Next
How to Create Lots of Crosstabs