Apply Statistics from a Spreadsheet#
To apply statistics from a spreadsheet to a dataset, use the Apply Statistics Sheet command.
Navigate to a dataset.
Click the Apply Statistics Sheet button on the Advanced area of the ribbon.
Select the Excel file that contains your statistics. See below for information on the required format.
A summary of changes to be made will be displayed.
To apply the changes, click Save. To discard the changes, click Cancel.
Generate a Statistics Spreadsheet#
To generate a statistics spreadsheet for a dataset, use the Create Statistics Sheet command.
Navigate to a dataset.
Click the Create Statistics Sheet button on the Advanced area of the ribbon.
Select where to save the spreadsheet.
Your spreadsheet will be saved.
Spreadsheet Format#
The spreadsheet must have two worksheets with the following names:
Statistics
Frequencies
Statistics Worksheet Format#
The Statistics worksheet must have the following columns.
- VariableName
Required. The name of the variable to which the statistics apply. This variable must appear in the dataset.
- WeightVariableName
Optional. The name of the variable used as a weight. If left empty, the statistics are unweighted.
- TotalResponses
The total count of rows in the data.
- Valid
The number of rows with valid data.
- Invalid
The number of rows with invalid, or missing, data.
- Minimum
The lowest valid value in the data.
- Maximum
The highest valid value in the data.
- Mean
The mean of all valid values in the data.
- StandardDeviation
The standard deviation of all valid values in the data.
- Variance
The variance of all valid values in the data.
Frequencies Worksheet Format#
The Frequencies worksheet must have the following columns.
- VariableName
Required. The name of the variable to which the statistics apply. This variable must appear in the dataset.
- WeightVariableName
Optional. The name of the variable used as a weight. If left empty, the statistics are unweighted.
- CodeValue
The value of the category as it appears in the dataset.
- Label
The value of the category as it appears in the dataset. This is only for information to assist in editing the spreadsheet.
- Frequency
The count of times this value occurs in the data.