GLSS-Logo_White

How To Run A Multiple Regression Test In SigmaXL

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.

GLSS is the leading provider of Lean Six Sigma Training & Certification. Our integrated Project-Based Learning approach helps everyone complete Lean Six Sigma projects 3x faster than outdated approaches. Partner with us to create a Culture of Continuous Improvement.
Search

What courses would you like to see from GLSS? Check all that apply.

start training

try it free
ico-arrow

START PROJECT

TRY KURE
white-ico-arrow

START TRAINING

try it
free

START YOUR FREE GREEN BELT TRAINING

Accredited by PMI. 100% Online & Self-Paced.