QI Macros will perform the regression analysis calculations for you:Īnalysis: If R Square is greater than 0.80, as it is in this case, there is a good fit to the data.Click and drag over your data to select it and then click on QI Macros, Statistical Tools and 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. ![]() Statistical Analysis Excel » Regression Analysis Regression Analysis in Excel You Don't Have to be a Statistician to Run Regression Analysis
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |