software

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: www.excelforum.com/member.php...oamp;userid=31788
View this thread: www.excelforum.com/showthread...hreadid=515168
try the linest function--
duane------------------------------------------------------------------------
duane's Profile: www.excelforum.com/member.php...oamp;userid=11624
View this thread: www.excelforum.com/showthread...hreadid=515168Prior to Excel 2003, LINEST returned incorrect R^2, F, and SSreg values if
the intercept was forced through zero

support.microsoft.com/kb/828533

Jerry

quot;duanequot; wrote:

gt;
gt; try the linest function
gt;
gt;
gt; --
gt; duane
gt;
gt;
gt; ------------------------------------------------------------------------
gt; duane's Profile: www.excelforum.com/member.php...oamp;userid=11624
gt; View this thread: www.excelforum.com/showthread...hreadid=515168
gt;
gt;