User Guide
×
Menu
Index
 

Displaying Statistic Labels in Spreadsheets

 
 
Under the User Settings - Calculations, you can find Default Place and Display of Statistics.
 
 
 
 
This setting now controls the crosstab orientation properties for the default placement of statistics as well as showing the statistic labels in the spreadsheet results when the row option is selected.
 
The three available settings are:
 
 
1. Columns setting:
 
 
 
2. Rows setting:
Note: Column B includes the label (% of column, sample) for categorical questions.
 
 
 
 
Rows, Suppress Statistic Labels
 
The question statistic format labels (% of column, sample) for categorical questions are now hidden in the spreadsheet output.
 
If exported to a spreadsheet, the question statistic format labels (% of column, sample) will be included as comments in the XLSX file.
 
Note: This setting that suppresses question format labels applies to categorical questions only.
It does not apply to numeric questions such as mean or Top Box.
Labels for numeric questions are still shown.