2.1.2.1 - Minitab: Two-Way Contingency Table

2.1.2.1 - Minitab: Two-Way Contingency Table

Minitab®  – Two-Way Contingency Table

This example will use data collected from a sample of students enrolled in online sections of STAT 200. 

WCStudentData.csv

To create a two-way table of the Work Status and Primary Campus variables in Minitab:

  1. Open the data file in Minitab 
  2. From the tool bar, select Stat > Tables > Cross Tabulation and Chi-Square
  3. We have a data file where each row represents one case, so we will keep the default data entry method of Raw data (categorical variables) in the drop down menu
  4. Click in the Rows box, then double click the variable Work Status to insert it into the Rows box on the right
  5. Click in the Columns box, then double click the variable Primary Campus to insert it into the Columns box on the right
  6. Click OK

This should result in the two-way table below:

Tabulated Statistics: Work Status, Primary Campus
Rows: Work Status  Columns: Primary Campus
  Commonwealth Campus University Park World Campus All
Full-time 0 26 78 104
Not working 1 99 25 125
Part-Time 4 96 12 112
Missing 0 2 0 *
All 5 221 115 341
Cell Contents: Count  
Video Walkthrough

Additional Display Options

The default in Minitab is to display the counts. Under Display you also have the option to select Row percentsColumn percents, and Total percents.

 

Screenshot of Minitab showing where to select the row percents, column percents, and total percents

 

The output below is what you would get if you selected all four display options:

 

Tabulated Statistics: Work Status, Primary Campus
Rows: Work Status  Columns: Primary Campus
  Commonwealth Campus University Park World Campus All
Full-time

0

0.00

0.00

0.00

26

25.00

11.76

7.62

78

75.00

67.83

22.87

104

100.00

30.50

30.50

Not working

1

0.80

20.00

0.29

99

79.20

44.80

29.03

25

20.00

21.74

7.33

125

100.00

36.66

36.66

Part-Time

4

3.57

80.00

1.17

96

85.71

43.44

28.15

12

10.71

10.43

3.52

112

100.00

32.84

32.84

Missing

0

*

*

*

2

*

*

*

0

*

*

*

*

*

*

*

All

5

1.47

100.00

1.47

221

64.81

100.00

64.81

115

33.72

100.00

33.72

341

100.00

100.00

100.00

Cell Contents
    Count
    % of Row
    % of Column
    % of Total

 

 

Here, each cell contains four values. The top number in each cell is the count. This is the number of students in that group. For example, there were 78 World Campus students who were working full-time.

The second number in each cell is the percentage of the row. In the cell for World Campus students working full-time, that value is 75.00. The row represents the students who were working full-time. This means that 75% of all students who were working full time were World Campus students. This is an example of a conditional probability: P(World Campus | Full-Time).

The third number in each cell is the percentage for that column. In the cell for World Campus students working full-time, that value is 67.83. The column represents World Campus. This means that 67.83% of all World Campus students were working full-time. This is an example of a conditional probability: P(Full-Time | World Campus).

The last number in each cell is the percentage of the total. In the cell for World Campus students working full-time, that value is 22.87. This means that 22.87% of all students who completed this survey were World Campus students who were working full-time. This is an example of an intersection: P(World Campus ∩ Full-Time).


Legend
[1]Link
Has Tooltip/Popover
 Toggleable Visibility