Previously using Lotus123 I could compare a Y column of data to one or more X
columns, getting the coefficients of correlation, a constant, and a multiplier of X that produces expected value of Y. Thus Y = A + BX . A being the constant and B the multiplier of X to produce the expected value of Y for any input of X. In openoffice statistics COREL produces the coefficient of correlation,
but I have not been able to get the other values. I have tried FORECAST, which may or may not be the right one, but have mismanaged such as to get no results The same applies to LINEST under ARRAY. I must be too ignorant to solve this. Any help?
It sounds like you want to make a trend line, or at least get the equation for it. OOo does not inherently do this. There have been many conversations and threads about this topic over the time I have been here. I don't have them saved, but you could search the archived. I am pasting below tips to find OOo answers.
HTH.
1) Use OOo help. 2) Go to <<documentation.openoffice.org>>. Search the *docs*, *FAQs* and *How To's*. Many questions are already answered. 3) Scan the mailing list archives for related messages. You can search the users list here <<http://tinyurl.com/6edyk>>. 4) Use Google or other search engine. 5) If these fail, then ask on an appropriate list.
These tips are expanded upon at <<http://tinyurl.com/3qy4k>>.
-- Peter Kupfer OOo user since 'OO4 http://peschtra.tripod.com/open_office/ooo_front.htm
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
