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?

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
>
>