obtaining regression equation from excel data analysis

OBTAINING REGRESSION EQUATION FROM EXCEL DATA ANALYSIS FREE

Residuals Output, Probability Output and Charts For example, if the % of paved roadway = 1% the Salt concentration could be estimated as 17.547* (1%) +2.6765 = 20.2235 mg/l. Using the equation, y = Salt concentration = 2.677 + 17.547*(% paved roadway area), you could predict the salt concentration based on the percent of paved roadway.

Use the Equation for Prediction and Estimation In other words, there is a relation between the two variables. Since the p value ( 0 < 0.05), we 'Reject the Null Hypothesis' that the two variables are unrelated. 951 means that 95.1% of the variation in salt concentration can be explained by roadway area. Some statistics references recommend using the Adjusted R Square value. Evaluate the R Square value (0.951)Īnalysis: If R Square is greater than 0.80, as it is in this case, there is a good fit to the data. NOTE: If the first cell of your y values column is blank, that column of data will be omitted from your Regression output.

QI Macros will automatically perform the regression analysis calculations for you:.

Next, select your data and click on QI Macros > Statistical Tools > Regression & Other Statistics > Regression:.

Enter your data into Excel with the independent variable in the left column and the dependent variable in the right column.

This sample data is found in QI Macros Test Data > statistical.xlsx > Regression Data: What if we wanted to know if the salt concentration in runoff (dependent variable) is related to the percent of paved roadway area (independent variable). Regression arrives at an equation to predict performance based on each of the inputs. The purpose of regression analysis is to evaluate the effects of one or more independent variables on a single dependent variable. You Don't Have to be a Expert to Run Regression Analysis!

QI Macros will do the math and analysis for you.

Click on QI Macros menu > Statistical Tools > Regression.

OBTAINING REGRESSION EQUATION FROM EXCEL DATA ANALYSIS FREE

Free Agile Lean Six Sigma Trainer Training.Animated Lean Six Sigma Video Tutorials.Statistical Analysis - Hypothesis Testing.

Obtaining regression equation from excel data analysis