# 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