Split Combined Data by a Group Identifier

Menu location: Data_Organizing_Split Combined Groups.

This function splits a data column into other data columns according to one or more group identifier columns. The split data are put into new workbook columns that are marked Name~G=m, Name~G=f etc, where Name is the original combined data column label and G=x represent the group identifiers that you selected. It is wise to keep identifier schemes simple.

Example

Gp

Data --->

Data~Gp=1

Data~Gp=2

Data~Gp=3

1

1.1

1.1

0.7

1.9

1

1.3

1.3

1.0

2.2

1

0.9

0.9

0.6

1.7

2

0.7

1.5

1.1

2

1.0

1.3

3

1.9

1

1.5

1

1.3

2

0.6

3

2.2

3

1.7

2

1.1

Some other statistical packages require group identifier columns for group comparison tests, where all data are expected to be in a single column. StatsDirect does not do this for simple group comparison methods because separate data columns aid comprehension of the analysis. If you need to share data between StatsDirect and statistical packages that require group identifiers then use this function and the combine groups function to prepare data prior to import/export.