Home / Statistical Tools / Analysis Tools / Scatterplot / How-To / Multiple X/Y Pairs
Multiple X/Y Pairs¶
When you select multiple X columns or multiple Y columns, Quantum XL creates a scatter plot for each X/Y combination. This lets you explore how different variables relate to the same outcome.
Goal¶
Create scatter plots for Temperature vs Yield and Pressure vs Yield, comparing which variable has a stronger relationship with Yield.
Sample Data¶
Press Copy for Excel, then paste the table into a blank worksheet.
| Temperature | Yield | Pressure |
|---|---|---|
| 150 | 77.2 | 30 |
| 160 | 78.5 | 32 |
| 170 | 81.3 | 35 |
| 180 | 84.1 | 33 |
| 190 | 85.7 | 38 |
| 200 | 88.9 | 36 |
| 210 | 90.2 | 40 |
| 220 | 93.6 | 42 |
| 230 | 94.8 | 39 |
| 240 | 97.1 | 45 |
Each row has three measurements. We want to see how both Temperature and Pressure independently relate to Yield.
Steps¶
-
Put the data in Excel
Press Copy for Excel above the table, click cell A1 in a blank worksheet, and press Ctrl+V. The header row lands in row 1 and the 10 data rows in rows 2 through 11.
-
Launch the analysis
From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Scatter Plot.
-
Select your data
Select cells A1:C11 (the header row plus all 10 data rows across all three columns).
-
Configure the analysis
In the Scatter Plot dialog, Quantum XL automatically selects "Temperature" as X and "Yield" as Y (the first two columns). To add the second X column:
- X Columns: Check "Pressure" (Temperature should already be checked)
- Y Columns: "Yield" should already be checked
- Regression: "Linear" should be selected
Click Finish to generate the charts.
Result¶
Quantum XL creates two scatter plots:
Temperature vs Yield: Shows a strong positive linear relationship. Compare the R² value to assess fit quality.
Pressure vs Yield: Shows the relationship between pressure and yield. Comparing the R² values between the two charts reveals which variable is a better predictor of yield.