Detabulate

 

Menu location: Data_Grouping_Detabulate.

 

This a function to expand a two way table of counts into a column indicator variable and a row indicator variable, i.e. to deconstruct a table back into individual level data. This is the opposite of crosstabs or the tabulate function.

 

Example

Given the following table:

 

  reaction:0 reaction:1 reaction:2
sex:0 2 2 1
sex:1 1 1 3

 

You can use the Data_Grouping_Detabulate menu item on the two by three table of counts to get back to individual level data with each row representing the classification of a subject as follows:

 

Row Classifier Column Classifier
0 0
1 1
1 2
0 2
1 2
0 1
0 0
0 1
1 2
1 0

 

 

Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.