Frequency Tables

The Frequency Tables commands calculate tables of frequency counts (one-way or multi-way tables) and percentages for discrete or continuous variables. For discrete data, the table shows the number of observations for each unique value of the variable. For continuous data, the table shows the number of observations for each bin.

How To

ü  Run: Statistics→Basic Statistics→Frequency Tables (discrete data)... or Frequency Tables (continuous data)...

ü  Select input variables.

ü  Optionally, select a frequency variable. Frequency variable specifies the number of observations that each row represents. When omitted, each row represents a single observation.

ü  Optionally, select a layer/break variable. Layer variable distinct values will cause separate tables to be generated.

ü  Frequency and layer variables size must match input variables cases count.

ü  Continuous variables only: to change bins count or set up bins manually using the Advanced Options.
Minimum value is the left boundary of the first interval. Must be less than the minimum data value.

Results

Table with frequency counts for each variable (and for each level of the layering variable, if any) is produced.

Discrete variables

 – value of the input variable.

Count - the number of observations for each unique value of the variable ().

Cumulative Count - the number of observations with a value less than or equal to the .

Percent – percentage of  compared to the count of all observation.

Cumulative Percent - percentage of the observations with a value less than or equal to the  compared to the count of all observation.

Continuous variables

 to  - bin range.

Count - the number of observations falling within bin range.

Cumulative Count - the number of observations range less than or equal to right boundary of the range.

Percent – percentage of observations compared to the count of all observation.

Cumulative Percent - percentage of the observations with a value less than or equal to the right boundary of the range compared to the count of all observation.

Example

The grades awarded for an assignment set for a class of 22 students were as follows:

[FreqTables 1.xls, “Grade” variable]

To construct a frequency table run the Statistics→Basic Statistics→ Frequency Tables (continuous data)... command, select Mark as the continuous variable.

Let’s group the data into five class intervals from 1 to 100. Interval width would be 20. In the Advanced Options: enter number of intervals, minimum value and width of an interval as shown below:

Click the OK button to get a report with frequency table(s).

From the third row we could see that 22.7% of students have grades between 40 and 60 and 45% of students were scored less than 60.