Grouped Column Data
Why grouped charts?
Grouped charts are a great way to visualize numeric values plotted against two categorical variables instead of one.
Grouped charts are very similar to column or row charts, the difference being values are grouped by position for the primary categorical variable and by color for the secondary categorical variable.
primary categorical variable. i.e. monthly summaries 20XX-Jan, 20XX-Feb, 20XX-Mar, etc.Grouped charts allow you to see changes within-groups (changes in the secondary variable within levels of the primary), as well as see changes between-groups (changes in the primary variable across levels of the second).
Data entry
If you select a grouped column chart a table is generated with 2 columns for your categorical variables (Factor A & Factor B) and a 3rd column called Outcome for your numerical values.
| Factor A | Factor B | Outcome |
|---|---|---|
| Wild Type | Control | 100 |
| Wild Type | Treatment 1 | 100 |
| Wild Type | Treatment 2 | 105 |
| Knockout | Control | 25 |
| Knockout | Treatment 1 | 45 |
| Knockout | Treatment 2 | 55 |
Arrange your data such that each outcome value corresponds to
2categories.
When working with paired or dependent samples (i.e. before and after treatment). The sample size and ordering of your data should be conserved across the dependent samples.
Paired samples should be entered in such a way that once samples are filtered into their individual groupings they should end up in the same indexable order.
To illustrate how to order paired samples, an example is provided below with an additional column indicating the subject ID for clarity.
| ID# | Factor A | Factor B | Outcome |
|---|---|---|---|
| #1 | Before | Control | 100 |
| #2 | Before | Control | 105 |
| #3 | Before | Treatment | 102 |
| #4 | Before | Treatment | 98 |
| #1 | After | Control | 15 |
| #2 | After | Control | 20 |
| #3 | After | Treatment | 45 |
| #4 | After | Treatment | 60 |
Key features
- The first 2 columns represent categorical variables, while the 3rd is for numerical values.
- Categorical variables accept words, numbers or characters as input
- If your data is not paired (independent samples). You can enter your data in any order.
- If your data is paired (dependent samples) (i.e. before and after treatment) paired samples should be entered in the same order (ie. subjects filtered down into their individual groupings should be indexed in the same order).
When you're ready to plot, Graphmatik will automatically parse your data and calculate all necessary descriptive statistics when navigating over to the chart workspace.
Types of grouped charts
You can create 5 types of grouped charts. Select from the plots below to learn more.
Statistical analyses supported
- Descriptive statistics
- Two-way ANOVA (coming soon)