Crosstabs, or cross-tabulations, are powerful analytical tools that enable users to explore the relationships between two or more variables in their data. They provide valuable insights into patterns and correlations. By incorporating crosstabs, Fuel Cycle allows users to conduct complex data analyses directly within the system, eliminating the need for external software and streamlining the research process.
Crosstabs are typically visualized as tables that display the relationship between two or more variables. The columns represent specific demographics of interest to a client, while the rows usually consist of answer choices.
This analysis aims to perform significance testing on top of the data. For example, if the focus of the crosstab table is on juice flavor purchases, understanding any significant differences among age groups could be crucial for determining how to position a product or service.
Compatible Question Types
Survey question types you would use to produce information for a Crosstab would include the following:
- Single Select
- Multi-select
- Grid single select
- P2
Create a Crosstab
You can generate crosstabs immediately from any published project with compatible question types.
- Click the Projects navigation icon on the left.
- Select the project to analyze.
- The Insights menu appears automatically. Click the Crosstabs report.
The first time you see the Crosstabs screen, it is a blank slate. The screen is divided into several panes.
Crosstab Settings
Field List and Field Search
The left Field List contains all survey questions and P2 fields. Survey questions have a list icon, and P2 fields have a person
icon.
A Question Search field is also at the top of the panel. Start typing the question or P2 field name.
Column (Banner) Fields
To the right, you will find the Column (Banner) panel. As mentioned above, the columns represent specific demographics of interest to a client. Click and drag fields from the Field List panel to this panel.
Row (Stub) Fields
Beneath the Column panel is the Row (Stub) panel. The rows usually consist of survey answer choices. Click and drag fields from the Field List panel to this panel.
Click the Generate New Crosstab button to generate your table.
Display Settings
The Display Settings menu allows you to customize how data is displayed by adjusting decimal precision and selecting which metrics to show.
- Decimal Places—Determine the number of decimal places that Crosstabs should use when showing results.
-
Cells
- Count—Displays the number of data items in each cell.
- Row Percentage (%)—Shows each cell’s percentage relative to its row total for comparative analysis.
- Column Percentage (%)—Shows each cell’s percentage relative to its column total for assessing vertical trends.
-
Totals
- Row Total Count—Shows the total count for each row for deciding when summary data is useful
- Column Total Count—Shows the overall count for each column for evaluating the depth of information displayed.