Close this search box.

Multiple Linear Regression & Stepwise Regression

Multiple linear regression is used to answer these types of questions by finding if there is a linear relationship between an effect (ice cream sales) and possible causes (temperature and humidity). The SPC for Excel software contains regression as well as stepwise regression.

Watch a Video Featuring SPC for Excel's Regression Analysis

Join those in over 80 countries using SPC for Excel!

Multiple Linear Regression/Stepwise Regression and SPC for Excel

Multiple linear regression is a method used to model the linear relationship between a dependent variable and one or more independent variables. It allows you to examine what independent variables (x) impact a response variable (y) and by how much. SPC for Excel contains multiple linear regression that allows you to see if a set of x values impact the response variable. The output from the SPC for Excel software includes an in-depth analysis of residuals with potential outliers in red as well as multiple charts to analyze the results. You can easily remove independent variables as well as observations from the data and rerun the regression. You can also transform the y variables. SPC for Excel also contains stepwise regression. Stepwise regression is process of building a model by successively adding or removing variables based solely on the p values associated with the t statistic of their estimated coefficients. A complete list of regression features is given below.

Multiple Linear Regression Features

Stepwise Regression Features

Scroll to Top