Group building

Assigns samples to analytical groups by one or more categorical columns, for example burial, feature, material or phase. The result is a workbook with a summary of each group and one sheet per group, and a table with a Group column that can be used directly in cluster analysis, principal component analysis and ternary diagrams.

Input

Select a data file
CSV or Excel, one row per sample
Group by

Select a file to list its columns.

Select one or more columns. With several columns, each combination forms a group, in the order selected.
1
Groups with fewer samples are combined as "Other (small groups)". Samples with a missing value are listed as "Unassigned".

Results

Updates automatically
Select a file and at least one column.
Mean composition by group

Continue with the grouped table: