Overview

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.

This opens the Export to Excel panel:

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 entire 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, 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 Settings… at the bottom of the screen. This opens the customization screen. This same screen can also be opened from the main Export menu.

You can set the following options:

Measures

Percentages

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

Tests

The exported data can include any of the following statistical significance test statistics and tests: Z-score (standardized residual), P-value (the probability that the value differs significantly from the mean), or Column t-tests (performing pairwise tests between columns in each row – see Hypothesis testing in Crunch for more information).

Color cells

Color cells by P-values – If selected, cells will be shaded in the exported table based on the P-value associated with each cell’s Z-score (a display equivalent to turning on hypothesis testing in the application).

Count

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

Other measures

Standard deviation – Standard deviation of point estimates in each cell.

Standard error – Standard error of point estimates in each cell.

Index – Percentage of each cell relative to the row marginal percentage (which is treated as “100”). For example, if the marginal for the row is 30% and a given cell’s column percentage is 60%, the “index” is 200.

Population – Estimated population size included in the table if a dataset has a Target Population set.

Cell base

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

Rows/Columns

Show empty rows/columns – Show or hide rows and columns that are valid categories, but contain no data in a given table (this could be the result of, e.g., a filter being applied to the export).

Table Summaries

Mean – The scale mean of optional numeric values associated with categories. Numeric values may be null and need not be unique.

Median – The scale median of optional numeric values associated with categories.

Standard deviation – Standard deviation of estimates of scale values.

Standard error – Standard error of the estimates of scale values.

Base rows

For base rows, you can choose to display Unweighted, Weighted, or Both. As a rule, contingency tables should contain the base in the direction of percentaging to aid interpretation.

Base rows location

You can choose to display the base rows at the Top or Bottom.

Layout and format

Column Fields – When multiple fields are included for each table “cell” (e.g., Counts in addition to Percentages, Population Size, Index) are selected, they can be added to the same table row as the cell they apply to (Wide (across)) or to the same column (Long (down)).

Decimal places – Number of decimal places shown for Percentages (the default, 0, is usually most appropriate) and up to three decimal places to display for Other measures which may merit more precision. Note that XLSX tables contain the complete double-precision proportion and decimal formatting and rounding is applied as a cell format.

Table of Contents – Optionally include a table of contents worksheet as the first sheet or the top of a single-sheet export. It contains the row variable titles and links to the appropriate worksheet (or position in the single sheet if All variables on one sheet was selected).

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.

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.