Run|ExpressTabs

ExpressTabs allows you to create tables by selecting variables from your variable type data file as table rows and banner columns. Tables can be produced quickly whether you are a busy executive or a new data analyst. You can process tables filtered and/or weighted and reports can be printed or saved in most of the normal WinCross report formats (*.xml, *.rtf, *.xls, *.xlsx, *.pptx or *.pdf).

ExpressTabs is a quick and easy-to-use tool that can help you explore "what if" scenarios and/or whether your data supports further analysis.

Variables for rows/Variables for banner columns:

Find a variable

Allows you to enter search criteria to locate a specific variable. This is especially useful when there are many variables in your job file and you only want to select a specific variable or group of variables.

Find Next

Finds the next occurrence of the search value specified in Find a Variable. The Find Next button turns gray when no more occurrences of the search value are found.

Selecting variable(s) to be used as rows/columns

Select a variable or group of variables from the Variables for rows list to use for creating rows. Variables can be non-contiguous by selecting the Ctrl key when choosing variables from the list.
Select a variable or group of variables from the Variables for banner columns list to use for creating columns. Variables can be non-contiguous by selecting the Ctrl key when choosing variables from the list.

Table options

Run options

Use glossary transformations

Populates the list of variables for both rows and banner columns and creates tables with Glossary statements applied. These Glossary statements might include DELETE, DEFINE, DECLARE, LABEL, CODEVALUE, etc. and would affect which variables display in the list and/or how the tables are created.
The WinCross default is to Use glossary transformations.

Perform significance testing

Performs significance testing for percents when Statistics|Show Vertical Percent is selected. Performs significance testing for means when Statistics|Show Mean is selected. The Dependent Paired/Overlap (Multi) test is always used, however, if the data are independent the results would be the same as if the Independent (using unpooled proportions) Z-Test was used for percents and the Independent (assume unequal variances) T-Test was used for means.
By default, significance testing is done for all banner columns. You can use Define Comparison Groups to create alternative comparison groups to the WinCross default.

Cases to run

Enter the number of Cases to run. "Cases" is synonymous with "Respondents".
You can run all cases or just a subset. Running a subset can be a good way of testing your job file.

Run Filter

Run filter lets you enter a Filter Title (optional) and Filter Logic to be applied to your entire set of tables.
The Filter Title you specify is placed at the top of the page and is always left-justified. Filter titles can have up to 480 characters on up to 4 lines.
The Filter Logic can be simple or complex and can be up to 480 characters.
The Run Filter is active check box can be used to remove the Run Filter without removing the Filter Title and Filter Logic that was previously entered. This allows you to reuse the Filter Title and Filter Logic if desired.

IMPORTANT: When a Run Filter has been specified and the Run Filter is active check box is selected, the Run Filter will be applied to all subsequent processing of tables, frequencies and/or marginals. For example, if you add a Run Filter to your table processing using Run|Tables and then select Run|Frequency, the Run Filter check box will be selected because the Run Filter is still active. To remove the Run Filter, deselect the Run Filter is active check box on the Run Filter dialog.

Weight

Select the Weight variable from the list of Abbreviated/Variable Names or enter the record/column location or Variable name in the Weight field.
Enter the number of Implied decimal places if applicable.
Select Remove weight to remove a weight from the table processing.

IMPORTANT: When a Weight has been specified, the weight will be applied to all subsequent processing of frequencies and/or marginals. For example, if you add a Weight to your table processing using Run|ExpressTabs and then select Run|Frequency, the Weight check box will be selected because the Weight is still active. To remove the Weight, select the Remove weight option on the Weight Field dialog.

Swap the variables between rows and columns

You can reverse the variables selected for rows and columns using the option. Variable(s) selected for rows will be reversed with variable(s) selected for columns and variable(s) selected for columns will be reversed with variable(s) selected for rows.

Auto-run tables each time a variable is selected

Tables are created automatically when a variable(s) is selected.
When Auto-run tables is not selected, use Run Tables to create tables from the selected variables.
Tables are automatically created only when a Row variable is selected.
When a Row variable is selected without selecting a Column variable the table is created using a Total Answering column.
Selecting a Column variable without selecting a Row variable will not create a table.

Perform significance testing

Performs significance testing for percents when Statistics|Show Vertical Percent is selected. Performs significance testing for means when Statistics|Show Mean is selected. The Dependent Paired/Overlap (Multi) test is always used, however, if the data are independent the results would be the same as if the Independent (using unpooled proportions) Z-Test was used for percents and the Independent (assume unequal variances) T-Test was used for means.
By default, significance testing is done for all banner columns. You can use Define Comparison Groups to create alternative comparison groups to the WinCross default.

Cell width

Selecting the left-facing arrow reduces the size of all banner columns. Alternatively, you can use Reduce Cell Width from the View menu of ExpressTabs.
Selecting the right-facing arrow increases the size of all banner columns. Alternatively, you can use Increase Cell Width from the View menu of ExpressTabs.

Run Tables

When the Auto-run tables option is not selected, Run Tables must be used to create tables from the selected variables.

Create a WinCross Report

Creates an enhanced text format report of your tables that can be printed and/or saved to most of the normal WinCross report formats (*.xml, *.rtf, *.xls, *.xlsx, *.pptx or *.pdf).
Use File|Print|Print Report to print the enhanced text format report created using ExpressTabs.
Use File|Save|Save Report As to save the report in the desired format (*.xml, *.rtf, *.xls, *.xlsx, *pptx, or *.pdf).

Note: When you create a report using the Create a WinCross Report option, the ExpressTabs dialog closes and you cannot return to your previous selection of variables. You will need to select Run|ExpressTabs and reselect the variables.

Add Banner to Job File

Creates a banner from the selected Variables for banner columns and adds the banner to your open job file.
If a job file does not exist, you will be prompted to choose a profile and create a new job file.

Banner name

Banner name is required and must be unique to use the Add Banner to Job option.

Banner title

Banner title lets you give a descriptive title to your banner.
Enter the Banner title (up to 480 characters on up to 4 lines).
The Banner title is optional.

Filter title

Enter a Filter title (up to 480 characters on up to 4 lines).
The Filter title is optional.

Filter logic

Enter the Filter logic.
The Filter logic represents the variable name or location and the value of the data (for example, GENDER (1) or 1/5 (1)).
Filter logic is optional.

Column width, in characters

Specify the Column width, in characters from the dropdown menu.
The default Column width, in characters is 10.
Banner Column width, in characters must be a minimum of 4 and a maximum of 20.

Spaces before each column

Choose the number of spaces before each banner column from the Spaces before each column dropdown menu.
The maximum number of spaces between banner columns is 5.
The default Spaces before each column is 1.

Underline banner text

Use Underline banner text to add underlines to all banner and banner heading text.

Left justify

Use Left justify to left-justify the banner text in all cells of the banner.

Center justify

Use Center justify to center-justify the banner text in all cells of the banner.
All banner text is center-justified by default when creating a new banner using ExpressTabs.

Right justify

Use Right justify to right-justify the banner text in all cells of the banner.

Add Banner to Job

You must enter a Banner name to use the Add Banner to Job option.
Banner names must be unique. If the banner name entered here exists in your current job file, you will be prompted to replace the existing banner.
Select Yes to replace the existing banner.
Select No to enter a new unique banner name.

Note: The Setup|Job Settings|Enhanced Text Reports settings for the Report viewing format of Enhanced text report on the Run Tables dialog are not applied to reports created using ExpressTabs.

Comparison Groups

Statistics Menu

View Menu