Hi all,
Given a set of discrete x-data and y-data points, how does the LINEST function calculate the slope error if the y-intercept is set to zero?
Hi all,
Given a set of discrete x-data and y-data points, how does the LINEST function calculate the slope error if the y-intercept is set to zero?
It's ambiguous.
See http://www.excelforum.com/excel-gene...-to-0-0-a.html
Entia non sunt multiplicanda sine necessitate
The post you gave does not exactly answer my question, although it is interesting to see how Excel calculates R^2 for constrained and unconstrained linear regression.
The LINEST function gives a standard error for the slope when the intercept is forced to go through the origin. In this case, I have no idea how Excel is calculating this error at all. I have tried several different methods but can't seem to get the same answer as the LINEST function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks