Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Setting the constant to zero > Setting the constant to zero Share

Setting the constant to zero

Excel Help for Setting The Constant To Zero in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicLogin

Setting The Constant To Zero

Rate this:
(3/5 from 1 vote)
Confused If the curve is forced through zero, the intercept is set to 0 before the regression is calculated, thereby setting the bias to favor the low end of the calibration range by “pivoting” the function around the origin to find the best fit and resulting in one less degree of freedom.
Regards,Rachel Gomez
 rachel
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Setting the constant to zero in the