Multiple Regression Analysis in Excel | Regression Analysis in Excel

Multiple Regression Analysis
home · products · services · search · view cart · contact

NAVIGATION

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

When to use multiple regression analysis

The purpose of multiple regression analysis is to evaluate the effects of two or more independent variables on a single dependent variable.

Regression arrives at an equation to predict performance based on each of the inputs.

Here is an example of the results of running regression analysis in Excel using the QI Macros.

To run Regression Analysis using the QI Macros

Select the labels and data.
Select Anova and Analysis Tools then Regression Analysis.
Input the confidence level (e.g., 0.95).
Evaluate the Rsquared (>0.80 is a good fit), F and p values.

Here is a detailed example:

1. Select the data

Select two to sixteen columns with the dependent variable in the first (or last) column. Imagine, for example, we want to know if customer perception of quality varies with various aspects of geography and shampoo characteristics: Foam, Scent, Color or Residue.

2. Click on the QI Macros menu and
choose Anova then Regression Analysis:

3. Enter the confidence level (e.g., 0.95) and the QI Macros with Excel will generate the results.

4. Evaluate the R Square value (0.800), F and p values.

Analysis: If R Square is greater than 0.80, as it is in this case, there is a good fit to the data.

If	Then
p value < a	Reject the null hypothesis
p value > a	Accept the null hypothesis

The null hypothesis is that there is no correlation. (H₀ = no correlation.) Looking at the p values for each independent variable, Region, Foam and Residue are less than alpha (0.05), so we reject the null hypothesis and can say that these variables impact quality. Scent and color p values are greater than 0.05, so we accept the null hypothesis that there is no correlation and we can't say they directly impact quality.

The QI Macros Statistical Process Control software takes two or more rows/columns of data and formats them in the ideal way for Excel to process them which saves you from having to figure out how to use Excel's Data Analysis Toolpak. Here are some of the statistical analyses you can run.

Regression Analysis Video
Single Regression Example
Correlation Example
Covariance Example
Other forms of hypothesis testing in Excel

Regression Analysis is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Multiple Regression Analysis