Frequency Tables

When you have categorical data, you frequently desire to know how many of each group there are. A frequency table will provide this information. The TALLY command in MINITAB produces frequency tables. The following example tallies the 'SEX' column and the 'CLASS' column.

MTB> TALLY 'SEX' 'CLASS' ;


SUBC> ALL.

Here we specified the 'ALL' subcommand to produce cumulative counts, percents, and cumulative percents in our output.

The results would be as follows:

sex  COUNT CUMCNT PERCENT  CUMPCT     class  COUNT CUMCNT PERCENT  CUMPCT
1 11 11 55.00 55.00 1 9 9 45.00 45.00
2 9 20 45.00 100.00 2 4 13 20.00 65.00
N= 20 3 3 16 15.00 80.00
4 4 20 20.00 100.00
N= 20

Remember that we coded our sex variable to be 1 for males and 2 for females. The data shows us that we have 11 males for 55% and 9 females for 45%. For our class variable, we coded 1=freshman, 2=sophomore, 3=junior, and 4=senior. The table shows that we have 9 freshman, 4 sophomores, 3 juniors, and 4 seniors. The cumulative numbers are also helpful for this variable: 80% of our sample are freshman, sophomores, and juniors, 65% are freshman and sophomores.

Your rating: None Average: 1.3 (3 votes)