| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Polynomial Regression with Dates | Excel Discussion (Misc queries) | |||
| Polynomial Regression with Dates | New Users to Excel | |||
| Need furmula of R-squared by polynomial regression | Excel Programming | |||
| how to get coefficients for Polynomial regression as for rgp() | Excel Worksheet Functions | |||
| example of a polynomial regression analysis | Excel Programming | |||
Linear Mode
