Regression intercept to 0
 

Hello all,
I am writting a workbook to help calculate slopes and correlations from
a series of data points. Everything worked fine until I realized that I
was getting weird values. Turns out I need to set the intercept in the
regression to 0 before I calculate the slope and the correlation
coefficient.
Does anybody know how to turn =slope(x,y), and correl(x,y) into
formulas that will set the intercept in the regression to 0.
I must also mention that I am writting this to be used by people with
limited computer skills. I am trying to write formulas in which they
can only input x, and y data and it will spit out an answer. I know I
can do this by graphing the data and then setting the intercept, but
believe me I tried teaching them this and it was too much for them to
remember.
Any ideas?


--
squalidae
------------------------------------------------------------------------
squalidae's Profile: http://www.excelforum.com/member.php...o&userid=31788
View this thread: http://www.excelforum.com/showthread...hreadid=515168

Regression intercept to 0
 

try the linest function


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=515168

Regression intercept to 0
 

Prior to Excel 2003, LINEST returned incorrect R^2, F, and SSreg values if
the intercept was forced through zero

http://support.microsoft.com/kb/828533

Jerry

"duane" wrote:


try the linest function


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=515168