|
polynomial regression
Follow:
http://spreadsheetpage.com/index.php...line_formulas/ Consider using VBA to place the formulas in worksheet cells or use EVALUATE() to evaluate then directly. -- Gary''s Student - gsnu200825 "Lucile" wrote: Hello, I need to do a polynomial regression, 5th order. I think I am using the right formula: application.linest(x,y^{1,2,3,4,5}) My problem is that {} is not accepted! Invalid character. I am using excel 2000. What can I do to fix this problem? Thanks |
polynomial regression
I already tried that.
VBA doesn't accept { } character, so I can not write this formula! But thanks for the help! "Gary''s Student" wrote: Follow: http://spreadsheetpage.com/index.php...line_formulas/ Consider using VBA to place the formulas in worksheet cells or use EVALUATE() to evaluate then directly. -- Gary''s Student - gsnu200825 "Lucile" wrote: Hello, I need to do a polynomial regression, 5th order. I think I am using the right formula: application.linest(x,y^{1,2,3,4,5}) My problem is that {} is not accepted! Invalid character. I am using excel 2000. What can I do to fix this problem? Thanks |
| All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com