Controls recalculation of analysis results
For more information, see: Recalculating Analysis Results
The input data consists of one or more sample data columns and one factor (grouping) column.
The input data consists of one or more sample data columns.
If Indexed is selected for Input Data Form,
Enter the group data. The grouping column will be set as categorical if most of the column values are text. So you can easily reorder the output columns.
For help with range controls, see: Specifying Your Input Data
Enter the data to perform discrete frequency analysis.
If Raw is selected for Input Data Form
Tally counts on each discrete value.
Calculate the cumulative Count on each discrete value.
Calculate the relative frequency of each discrete value. Please see the algorithm here.
Calculate the cumulative frequency of each discrete value. Please see the algorithm here.
Specify the form of the frequency. Available when either the Relative Frequency or the Cumulative Frequency check box is checked.
Distinguish between uppercase and lowercase when deciding whether two values are the same.
Check this option to exclude both missing values and empty values.
Specify whether to list the category and show 0 as its count data when a
category is not found.
Controls output columns sorting order:
When Categorical Order is selected, the output column order will follow categorical order customized through (Column Properties) Categories tab.
Specify where to output the results. The identifier in the result sheet will use Long Name of input columns if there is no dupliacted Long Name.
For help with the range controls, see: Output Results