Arrangement of Input Data
overview 

Data used for input to the Tables procedures can be arranged in four different ways in your worksheet:

Raw data - one row for each observation:

C1

C2

1

1

2

1

2

3

1

2

C1= gender, C2 = politics

Contingency table - each cell contains counts:

C1

C2

17

18

10

19

19

17

C1= males, C2 = females

Rows 1-3 represent the three levels for politics

Frequency data - each row represents a unique combination of group codes:

C1

C2

C3

1

1

17

1

2

10

1

3

19

2

1

18

C1= gender, C2 = politics

Indicator variables - one row for each observation

C1

C2

C3

C4

C5

1

0

1

0

0

0

1

1

0

0

0

1

0

0

1

1

0

0

1

0

C1 = 1 if male, 0 if female

C2 = 1 if female, 0 if male

C3 = 1 if Democrat, 0 = otherwise

C4 = 1 if Republican, 0 = otherwise

C5 = 1 if Other, 0 = otherwise

To create:

·    frequency data from raw data, see Store Descriptive Statistics.

·    contingency table from raw data or frequency data, see Cross Tabulation and Chi-Square, then copy and paste the table output into your worksheet.

·    indicator variables from raw data, see Calc > Make Indicator Variables.