Home / Statistical Tools / Analysis Tools / Scatterplot / Examples / 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

Download ScatterPlot_MultipleXYPairs.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.

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

1. Launch the analysis

   From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Scatter Plot.

2. Select your data

   Select cells A1:C11 (the header row plus all 10 data rows across all three columns).

3. 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.