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.

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

How to arrange a two-way (contingency) table

In a two-way 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.

C1 C2
Male Female
17 18
10 19
19 17
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy