2.1.1.2.1 - Minitab Express: Frequency Tables

The following data set (from College Board) contain the mean SAT scores for each of the 50 states and Washington, DC, as well the participation rates and geographic region of each state. To get an idea of the pattern of variation of a categorical variable such as region, we can display the information with a frequency table, pie chart, or bar graph.

MinitabExpress  – Frequency Table

To create a frequency table in Minitab Express:

  1. Open the data set:
  2. On a PC: In the menu bar select STATISTICS > Describe > Tally
    On a Mac: In the menu bar select Statistics > Summary Statistics > Tally
  3. Double click the variable Region in the box on the left to insert the variable into the Variable box
  4. Under Statistics, check Counts and Percents
  5. Click OK

This should result in the following frequency table:

Tally
Region Count Percent
ENC 5 9.8039%
ESC 4 7.8431%
MA 3 5.8824%
MTN 8 15.6863%
NE 6 11.7647%
PAC 5 9.8039%
SA 9 17.6471%
WNC 7 13.7255%
WSC 4 7.8431%
N= 51  
Video Walkthrough

Select your operating system below to see a step-by-step guide for this example.