Regression intercept to 0

[squalidae]

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?

 

[duane]

try the linest function

 

[Jerry W. Lewis]

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