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
Names 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.

C1 C2 C3
Names Male Female
1 17 18
2 10 19
3 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 agreed with the survey.
C1 C2 C3
Gender Survey Response Total
2 1 17
1 2 10
1 3 19
2 1 18
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy