Crosstabs

A cross-tabulation, or contingency, table (crosstab) is an analytical tool used in market research to examine the relationship between two or more variables. Crosstabs organize data into categories and display them in a grid format, allowing researchers to identify patterns and relationships between different groups of respondents quickly. 

Crosstabs are often used for survey analysis, segmentation studies, brand tracking studies, customer satisfaction surveys, and other types of quantitative research.

The workflow is to create a new data set, access the Crosstabs app, adjust your data set, and then set up which data to use as crosstab tables.

To activate Crosstabs, Submit a Request to the DevOps/Product team.

Create a New Data Set

1. Click the Reporting tab at the top of the page. The landing page will be the FC analytics dashboard screen.
2. Create an FC Analytics data set to send to the Crosstabs application. If you have an integration to MarketSight enabled, you can also create a data set to send to MarketSight.
3. Once you complete which fields you'd like to create in the data set, click Save. You are redirected back to the FC Analytics dashboard.
4. Once you create a data set, the data set entry will display as processing until it's ready. The dataset will be ready for you once you see the Action drop-down.

Adjust Your Data Set

1. Select Create Crosstabs from your data set's Action menu. Your Crosstabs application opens in a new browser window. You will automatically log into the app through a single sign-on process.
   
   
2. If you wish to manipulate your data at all, you can do so in this data processing tab.
3. You can choose to upload an entirely new CSV file if needed along the left side of the screen.
   

   NOTE: This will completely replace the previously uploaded content. To add more to your existing data file, create a new data set within FC Analytics.

4. You will primarily want to rename any of your column labels to make them better defined.
5. You're also able to create categorical variables and merge any data that you need to.

Create Crosstabs

1. Once you're done manipulating your data, select the crosstabs tab to use these data fields to create a cross tab. Saving is automatic in this app as you switch between tabs.
2. Utilize filters based on any of the fields in your data set.
3. Implement heat mapping and chi-square tests, or manipulate your confidence intervals when it comes to those fields.
4. Create your crosstab based on the data rows and columns of your choice. For example, you might choose gender and income. You may select multiple rows and columns.
5. Choose your measures to choose which data you would like to see most often. For example, you might want to see a total count combined with the percent of the total.
6. Click Create. Your crosstab generates within moments (but larger data sets may take some time). 

Edit and rerun your crosstab at any time by manipulating the variables on the left and regenerating the table.

Download this table at any time to an Excel sheet by clicking the Download button in the bottom left.