# Sort data in subgroups

Sorting data into subgroup can give more information of your data. It is possible that some subgroups are having influence on the mean or variance. Here is described how sort data in to subgroups.

First change the statistical mode to DOE

Now an extra table is added to for labeling the data.

Data file

In the Left column is labeled from witch production line the product is.

As you can see the average data from Line 2 is higher as line 1.

It is possible to add more data to sort, Simply add a column and add the labels to sort see below.

As you can see there is no other significant influence. In the graph the operator also looks significant but according the t-test it is not significant.

Be aware with labeling data with more than 1 subgroup (Factor) that has influence on the result the array with the labels easily in
unbalance
. This is also the case with data in the example (Jan is in 4 data points of Line 1 and only 3 data points of Line 2). So maybe the Operator is significant but due the unbalanced data it is not visible in the result.

When selecting the DOE Graphs it is easier to see the influence of each subgroup.

This is how the sorting looks internally in Develve.
 Factor All Factors Line Batch part Operator Levels Your Data 1 2 0043 XO78 Jan Henk 8.02 8.02 8.02 8.02 6.43 6.43 6.43 6.43 4.52 4.52 4.52 4.52 7.24 7.24 7.24 7.24 5.94 5.94 5.94 5.94 6.82 6.82 6.82 6.82 6.84 6.84 6.84 6.84 9.90 9.90 9.90 9.90 6.79 6.79 6.79 6.79 10.87 10.87 10.87 10.87 6.83 6.83 6.83 6.83 8.00 8.00 8.00 8.00 7.81 7.81 7.81 7.81 8.98 8.98 8.98 8.98 Mean 7.50 6.55 8.45 7.53 7.47 6.68 8.32 n 14 7 7 7 7 7 7 Median 7.04 6.82 8.00 6.82 7.24 6.83 8.00 STDEV 1.62 1.10 1.54 1.65 1.73 1.18 1.66