Exporting Tab Books

A tab book consists of some or all of the variables in the dataset crossed with a multitable header.

To export a tab book to Excel:

Create a multitable as described in Multitables, the click Export in the upper-right and select Export tab book from the dropdown menu.

image.png

This opens the Export to Excel panel:

image.png

On the left side of the panel, you can select which variables will be included as rows in the tab book. By default all variables will be selected.

On the right, you can set what weight and filters will be used in the exported tab book:

Filters – Select any filters that should be applied to the tab book. Any selected filters will be selected, and you can add and remove filters as described in Filtering Data. If the filter you want to use does not exist, click “cancel” to close the export panel, create the new filter object, and then return to the export panel.

Weight – Select a weight variable to compute a tab book with weighted data or select unweighted. If a weight was applied it will be selected by default. See Weighting for more information

Customizing the exported tab book

To customize how the resulting Excel file will be formatted, click Customize... at the bottom of the screen. This opens the customization screen.

image.png

You can set the following options:

Fields

Percentages – Percentages exported tables can be configured to sum to 100% across each Row, Column, or across the entire Table.

Tests – The exported data can include any of the following statistical significance tests: Z-score (the number of standard deviations from the mean), P-value (the probability that the value differs significantly from the mean), or Column t-tests (performing p-value tests across each cell in a row – see http://support.crunch.io/articles/c9e4yRRi/Hypothesis-testing-in-Crunch for more information).

Count – You can choose to display Weighted or Unweighted counts (or both). See Weighting for more information on weights.

Index percentage – If this option is selected each an index column will be added that displays the percentage of the cell relative to the mean for the row (which is treated as 100). For example, if the mean for the row was 30% and a given cell in the row was 60%, the index would be 200.

Population Size – Select this option to have population size included in the table. See Target Population.

Mean – Select this option to have tables include the mean value of categorical variables that have numeric values assigned to their categories.

Base N – You can choose to display a Weighted or Unweighted base (or both).

layout

Table of Contents – Set this option to Include to have the Excel workbook include a table of contents worksheet in the front. For each variable in the tab book, this table of contents will link to the appropriate worksheet (or position in the single sheet if All variables on one sheet was selected).

Column Fields – When extra cells (e.g. Population Size, Index) are selected, they can be added to the same row as the cell they apply to (Wide (across)) or to the same column (Long (down)).

Variables – By default, each variable in the tab book is written to its own worksheet in the exported Excel file. Select All variables on one sheet to write the entire tab book on a single worksheet; this can make it easier to navigate through the tab book in Excel.

format

Color cells by p-values – If selected, cells will be shaded in the exported table, similar to turning on significance testing in the application.

Show empty rows/columns – Select this option to show entirely empty rows and columns (this could be the result of, e.g., a filter being applied to the export)

Completing and downloading the export

Click Export to request the tab book. For large datasets, exporting can take some time. Once the Excel workbook is ready, a Download button will appear.

Click Download to download the Excel file.