Home / Statistical Tools / Analysis Tools / Dotplot / Examples / Multiple Data Columns
Multiple Data Columns¶
When you have multiple data columns, Quantum XL creates one dot plot per column, stacked vertically and sharing the same X-axis. This lets you compare distributions side by side.
Goal¶
Compare measurement distributions across three production batches to see differences in center, spread, and any unusual values.
Sample Data¶
Download DotPlot_MultipleDataColumns.xlsx
Excel Protected View
When you open downloaded files, Excel displays a Protected View warning. You must click Enable Editing before you can use Quantum XL with the file.
Alternatively, you can copy the sample data from the table below and paste it directly into a new Excel workbook.
| Batch A | Batch B | Batch C |
|---|---|---|
| 49.1 | 50.2 | 42.0 |
| 49.5 | 51.8 | 43.5 |
| 49.8 | 52.5 | 44.0 |
| 50.0 | 53.0 | 44.2 |
| 50.1 | 53.5 | 44.5 |
| 50.2 | 54.0 | 44.8 |
| 50.3 | 54.5 | 45.0 |
| 50.4 | 55.0 | 45.0 |
| 50.5 | 55.0 | 45.2 |
| 50.6 | 55.2 | 45.3 |
The table shows the first 10 of 25 rows. Download the full dataset above for the complete example.
Each column represents measurements from a different production batch. Batch A is tightly clustered around 50, Batch B is more spread out around 55, and Batch C is centered lower around 45.
Steps¶
-
Launch the analysis
From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Dot Plot.
-
Select your data
Select cells A1:C26 (the header row plus all 25 data rows across all three columns).
-
Configure the analysis
In the Dot Plot dialog:
- Data Columns: "Batch A", "Batch B", and "Batch C" should all be checked
Click Finish to generate the chart.
Result¶
Quantum XL creates three dot plots stacked vertically, all sharing the same X-axis. At a glance you can compare:
- Batch A has a tight cluster of dots near 50, indicating very consistent measurements
- Batch B has dots spread from about 50 to 61, indicating more variability and a higher center
- Batch C is centered near 45 with most dots tightly grouped, plus one isolated dot near 50 standing apart from the rest