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.

The spreadsheet must have two worksheets with the following names:

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.

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.