To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20819
------- Additional comments from [EMAIL PROTECTED] Wed Nov 26 18:09:00 +0000 2008 ------- Hello, Gathering information about polynomial trend line, I noticed that (again) solution is in front our eyes. An easy way to get polynomial trend line equation is given in Help of trend line dialog box : simply use LINEST function, with proper construction of X data. >From Help : The polynomial regression equation A polynomial regression curve cannot be added automatically. You must calculate this curve manually. Create a table with the columns x, x², x³, … , xⁿ, y up to the desired degree n. Use the formula =LINEST(Data_Y,Data_X) with the complete range x to xⁿ (without headings) as Data_X. The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
