Multiple Regression Analysis

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.

Multiple Regression Analysis Example

Let's say we want to know if customer perception of shampoo quality (dependent variable) varies with various aspects of geography and shampoo characteristics: Foam, Scent, Color or Residue (independent variables).

To Conduct Multiple Regression Analysis Using QI Macros for Excel

  1. Select two to sixteen columns of data with the dependent variable in the first (or last) column:
  2. multiple-regression-analysis

  3. QI Macros will ask you which column the dependent variable (Y Value) is in. In this example, its in the first column:
  4. multiple regression analysis dependent variable

  5. QI Macros will perform the calculations and display the results for you:

Evaluate the R Square value (0.800)

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

Evaluate the p value

The null hypothesis is that there is no correlation. (H0 = 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 cannot reject the null hypothesis that there is no correlation and we can't say they directly impact quality.

Use the Equation for Prediction and Estimation

Using the equation below, you could predict the perception of shampoo quality based on the independent variables. Again, Region, Foam and Residue seem to have the greatest impact on the perception of quality.

y = 90.192 -3.859*Region +1.817*Foam +1.035*Scent +0.233*Color -4.001*Residue

Residuals Output and Probability Output

In addition to the Summary Output above, QI Macros also calculates Residuals Data and Probability Data. See the residuals analysis page foran example of how to plot this data:

multiple regression residuals output


Why Choose QI Macros Statistical Software for Excel?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets Results for You
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free