Dynamic Range for LinEst

Hi,
I have large arrays (n=1000 or more points) for which I would like to use LinEst for calculating best fit lines, quadratics, cubics. I would like to repeatedly calculate these for various length sub-arrays (5, 6, 7, 8, ...,50 points) starting at the first point, then the second point, then the third ... And I would like to do this without repeatedly going back and forth between the worksheet and the macro - just import the arrays using x1range and yrange.
Thank you,
Rags

Please Login or Register  to view this content.