17.1.5.1 The Discrete Frequency Dialog Box

Recalculate

Recalculate Controls recalculation of analysis results None Auto Manual For more information, see: Recalculating Analysis Results

Input Data Form

Indexed 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.

Input

If Indexed is selected for Input Data Form,

Group Range 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. For help with range controls, see: Specifying Your Input Data

If Raw is selected for Input Data Form

Input Enter the data to perform discrete frequency analysis.

Quantities to Compute

Count 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. Fraction The frequency is in the form of fraction. Percent The frequency is in the form of percent.

Case Sensitive

Distinguish between uppercase and lowercase when deciding whether two values are the same.

Exclude Missing Values

Check this option to exclude both missing values and empty values.

Show Zero Count Categories

Specify whether to list the category and show 0 as its count data when a category is not found.

Sort Data by

Sort Data by Controls output columns sorting order: Ascending Counts Descending Counts Ascending Values Descending Values Categorical Order When Categorical Order is selected, the output column order will follow categorical order customized through (Column Properties) Categories tab.

Output Results

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