Learner Login FAQ +1-650-690-2515

What’s A Multiple Regression Test?

The Multiple Regression Test is a hypothesis test that determines whether there is a correlation between two or more values of X and the output, Y, of continuous data. It is useful for determining the level to which changes in Y can be attributable to one or more Xs. Multiple Regression produces a “prediction equation” that estimates the value of Y that can be expected for given values of one or more X values within the range of the data set.

An example would be to test if crop yield were correlated to both rainfall and fertilizer amount, and then to calculate approximately how much water and fertilizer are required to achieve the desired yield.

Learn more about Multiple Regression Tests in Analyze Phase, Module 4.5.2 of Black Belt Training.

How To Run A Multiple Regression Test In SigmaXL

Download the GoLeanSixSigma.com Multiple Regression Test Data Set for SigmaXL here.

1. Select Raw Data:

MultipleRegressionTest-SigmaXL-RawData

2. Go to Statistical Tools > Regression > Multiple Regression:

MultipleRegressionTest-SigmaXL-SelectData

3. Click on “Next”:

MultipleRegressionTest-SigmaXL-Settings

4. Enter Variables as shown

5. Click on “OK”:

MultipleRegressionTest-SigmaXL

To learn more about Multiple Regression Tests, register for Black Belt Training and review Analyze Phase, Module 4.5.2.