Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linest use in vba
I would like to obtain the coefficient of a curve fitted cubic polynomial.
y=f(x) In excel I have used LINEST to obtain the coefficients. I have attempted to use LINEST from VBA without successs. The problem arises in the formating of the array equation {1,2,3} for the powers of x. Larry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linest use in vba
VBA has no concept of array formulas in the sense of Excel array formulas.
If your data is in a worksheet, you can use the VBA function EVALUATE(expressionstring) to evaluate an Excel aray expression in VBA, othewise you will have to to manually populate each element of a VBA array before passing that array to LINEST. Jerry "Larry" wrote: I would like to obtain the coefficient of a curve fitted cubic polynomial. y=f(x) In excel I have used LINEST to obtain the coefficients. I have attempted to use LINEST from VBA without successs. The problem arises in the formating of the array equation {1,2,3} for the powers of x. Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINESt | Excel Discussion (Misc queries) | |||
Another LINEST bug | Excel Worksheet Functions | |||
Need help with using LINEST() | Excel Programming | |||
LINEST() | Excel Worksheet Functions | |||
Linest - Why did they do that? | Excel Discussion (Misc queries) |