Skip to Main Content

Create a cross tab

Enter Search Terms

Simmons has a "smart search" feature.  Just start by typing keywords to search for a variable. 

enter search terms in the Simmons Search box

 

Create Rows or Columns

Add variables to either columns or rows by clicking the appropriate button. Your choice of whether you use columns or rows is up to you, as you are creating your own table.  

add variable in Simmons to a column or rows

 

Add more variables

Repeat the steps above to continue adding as many variables as you need to the columns.  

Continue adding variables to columns in Simmons as needed.

 

Create Rows

In order to create a cross tab, you have to create rows to compare with the data in your columns.  Search for variables, then add to Rows using the Rows button.

Add variables to rows in Simmons Insights

 

Run the Cross Tab

Click the "Run" arrow to run the Cross Tab analysis.

Click the Run button to run the Cross Tab in Simmons Insights

 

View your cross tab

The default "Private Eye" view is rather clunky to use.  In my opinion, e Cross Tab view is much easier to read.  

Click to change to Cross Tab view in Simmons

Export your work

The cross tabs you create can be exported to either an .XLS or .CSV for you to view and manipulate in Microsoft Excel or another spreadsheet application.

You can also save your cross tab as a .SPC file.  If you return to Simmons at a later time, you can upload the .SPC file to continue where you left off.

Click to export data in Simmons Insights

Creating a Simmons project