Table of Contents
Regression Analysis
“Eyeball” Method
Another Method: “Least Squares”
Use Excel to complete table
Calculate a & b using Excel
Regression Line for Units Sold and Population
Least Squares
Error = y - y
Least Squares produces regression line with best fit
Back to your spreadsheet ...
Back to your spreadsheet ...
Explained & Unexplained Variation
Explained & Unexplained Variation
R Square (R2)
Suppose y is not really dependent upon x …
How can we be sure that y is a function of x?
t is a test of significance
Simple Vs. Multiple Regression
Estimated Demand Function for Frozen Pies
Sample line approximates population regression line ...
Standard Error of Estimate
SUMMARY OF STEPS FOR PERFORMING REGRESSION
|
Author: Frederica Shockley
|