Worksheet arrangements for data types

Data for Minitab's table analyses can be arranged in the worksheet with different layouts.

How to arrange raw data

With raw data, there is one row for each observation.

The numbers in each column represent the following:
  • Gender: 1 = Female, 2 = Male
  • Survey Results: 1 = Agree, 2 = Neutral, 3 = Disagree

Row 1 represents a female that agreed with the survey question.

C1 C2 C3
Respondent Gender Survey Results
1 1 1
2 2 1
3 2 3
4 1 2

How to arrange a contingency table

In a contingency table, each cell contains counts.

The rows represent the following:
  • Row 1 = Agree
  • Row 2 = Neutral
  • Row 3 = Disagree

Row 1 indicates that 17 males and 18 females agreed with the survey question.

C1 C2
Male Female
17 18
10 19
19 17

How to arrange frequency data

With frequency data, each row represents a unique combination of groups or factors.

The numbers in the columns Gender and Survey Response represent the following:
  • Gender: 1 = Female, 2 = Male
  • Survey results: 1 = Agree, 2 = Neutral, 3 = Disagree
Row 1 indicates that 17 males (gender = 2) agreed (survey response = 1) with the survey question.
C1 C2 C3
Gender Survey Response Total
2 1 17
1 2 10
1 3 19
2 1 18