Linear Regression Using MS Excel

 


Click here to start


Table of Contents

bullet

Linear Regression Using MS Excel

bullet

The Regression Procedure

bullet

Step 1: Import Original Data to Excel

bullet

Step 2: Calculate the Correlation Matrix

bullet

Step 3: Assume a Functional Form

bullet

Step 4: Transform the Function into a Linear Equation

bullet

Step 5: Prepare Data for Regressing the Linear Equation

bullet

Step 6: Regress the Equation Using MS Excel

bullet

Step 7: Analyze the Quality of the Regression

bullet

Good News

 Author: Dr. Liping (Lee) Fu, Department of Civil Engineering, University of Waterloo, Waterloo, ON, Canada

Email:     lfu@uwaterloo.ca