How to automate the LINEST function in vba to find the best fit for a second order or higher polynomial?
Posted on 2009-04-08
I have hundreds of data sets showing change (y) over time (t) at different locations. I am attempting to plot the (y,t) data for each location and fit a second order polynomial line of regression to each of the data sets. I would like to automate the LINEST function in VBA to accomplish this by finding the constants C1, C2, and b; i.e. y = C1*t^2 + C2*t + b. I would also like the statistical data that LINEST provides.