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 |
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 |
All times are GMT +1. The time now is 04:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com