Designing Crosstabs

Overview

MarketSight's drag and drop editor allows you to easily make crosstabs to determine whether there are significant results in your data. Crosstabs must have at least one row variable. If there are no column variables in your design, a "Totals" column will be shown instead.

To make the designer more convenient, you can drag and drop multiple variables at once by using a shift+click, or you can drag and drop entire variable categories.

Watch this video to learn more.

MarketSight Crosstab Designer

Create a Basic Crosstab

  1. On the Crosstabs list page, click New
  2. Specify a name for the new crosstab (A)
  3. On the Design tab, drag variables from the left box to the appropriate section (Columns, Rows, etc.) in the right box (B) - use the diagonal double-headed arrow next to the Columns tab to Transpose variables back and forth
  4. If auto-preview is turned on, the right pane will update (C)
  5. Click Save or Save As (D)
  6. Click Close Editor to maximize viewing space (E)

Create a Crosstab with Nested Tables

  1. On the Crosstabs page, click New
  2. Specify a name for the new crosstab
  3. On the Design tab, drag one variable from the left to the Columns or Rows area on the right
  4. Drag a second variable from the left onto the name of the first variable in the right box
  5. Repeat as necessary
  6. Click Save
  7. Click Close Editor to maximize viewing space

Create a Crosstab with Grid Variables

  1. If necessary, first create a multiple response variable that is set to "Count All Values."
  2. In the left-most pane of the crosstab editor, open the Grid Variables category at the bottom of the list
  3. The multiple response variable will appear here - drag it to either the columns or the rows
  4. MarketSight will generate the full grid

Create a Crosstab with Automatic Date Ranges

MarketSight Automatic Date Ranges

  1. On the Crosstabs page, click New
  2. Specify a name for the new crosstab
  3. On the Design tab, drag one date variable from the left to the Columns box on the right (Note: this variable MUST be in date format)
  4. Click on the "Create Value Ranges" link that appears to the right of the variable in the Columns box
  5. Choose your date range settings from the menus

Set Custom Date Formatting for Automatic Date Ranges

  1. After opening the "Create Value Ranges" dialog, enter a combination of the following into the case-sensitive "Custom Format Template" box in the lower right corner
Symbol Resulting Date Format
d Displays the day as a number without a leading zero.Examples: 1, 31
dd Displays the day as a number with a leading zero.Examples: 01, 31
ddd Displays the day as an abbreviation.Examples: Sun, Sat
dddd Displays the day as a full name.Examples: Sunday, Saturday
w Displays the day of the week as a number.Examples: 1 (Sunday) through 7 (Saturday)
ww Displays the week of the year as a number.Examples: 1, 54
m Displays the month as a number without a leading zero.Examples: 1, 12
mm Displays the month as a number with a leading zero.Examples: 01, 12
mmm Displays the month as an abbreviation.Examples: Jan, Dec
mmmm Displays the month as a full month name.Examples: January, December
q Displays the quarter of the year as a number.Examples: 1, 4
y Displays the day of the year as a number.Examples: 1, 366
yy Displays the year as a two digit number.Examples: 00, 99
yyyy Displays the year as a four digit number.Examples: 1000, 9999

Create a Grid Question Crosstab

Grid questions in MarketSight are created by using select multiple response variables in the columns or rows of your crosstab. If multiple response variables are not already present within your dataset, you will want to go to the Variables page to create one. In order to use multiple MRVs within the same table, each MRV must share the same column values.

MarketSight Crosstab Grid Questions

  1. Open the "Grid Variables" category in the left list (A)
  2. Drag the desired variable into your columns or rows (B)

Transpose Variables in a Crosstab

MarketSight Crosstabs Transpose

  1. Click on the Transpose option (A or B)

Sort a Crosstab

  1. When viewing your crosstab, click on Sort Options in the right preview window, next to the column headers
  2. Select desired sort settings
  3. Click OK

Suppress Empty Columns or Rows

If your crosstab contains column(s) or row(s) that do not contain respondents (all values are shown as 0) or data (all values are shown as dashes), you can hide those from view.

  1. Click on the "Hide Empty Columns" or "Hide Empty Rows" checkboxes on their respective tabs

MarketSight Suppress Empty Columns and Rows

MarketSight Suppress Empty Columns and Rows

Crosstab Editor Shortcuts

  • If all variable values are deselected, use Alt+Click to select everything BUT the value alt-clicked on
  • If all variable values are selected, use Ctrl+Click to deselect everything BUT the value ctrl+clicked on

Crosstab Layout Options

MarketSight offers several layout options based on the calculations and row variables you've added to your crosstab.

Display calculations in rows

MarketSight Crosstabs

Display calculations in columns

MarketSight Crosstabs

Display calculations in mixed

This mode displays value-level calculations in columns and variable-level calculations in rows.

MarketSight Crosstabs

Display values in rows

This is the MarketSight default.

MarketSight Crosstabs

Display values in columns

Displays values in columns. This mode is only available if all row variables in a crosstab share the same set of responses. Note: No statistics are run when values are displayed in columns.

MarketSight Crosstabs

Change Layout Options

  1. When looking at your crosstab, click the Layout Options button
  2. Select the desired setting
  3. Click outside the box to close
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us