Betty Hudson wrote:
I want to be able to calculate the slope, intercept, and r-square for a
series of x-y values that have a linear relationship. What path
(please be
detailed as I am not a
mathematician) do I take in OpenOffice 2.0 to do this? I work in a
clinical
lab and need to do comparison studies between similar instruments that I
report lab results on.
Thanks...
You can do exactly what you are asking in Calc. You'll need to have some
basic concept of how functions in general work, in either Calc or Excel
(they work very similarly, so if you know how they work in Excel, you're
in good shape).
A step by step set of instructions to do what you want is somewhat
beyond the scope of this list, but I can point you in the right direction.
The functions you want are: SLOPE, INTERCEPT, and CORREL.
Go to the cell where you want the slope displayed. Click the function
wizard button on the toolbar; it is "f(x)", and on my display, is
directly above the column heading for column B. Scroll down the list of
functions to find the SLOPE function. Click on SLOPE, then click Next,
and the function wizard will help you construct the function properly.
Do the same for INTERCEPT and CORREL.
One caution: I believe the CORREL function returns R, not R-squared. It
wasn't specific about this, and I didn't have time to delve into it.
Let us know if you have any further questions. Please reply to
[email protected] only.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
