Trying to run regresssion on about 500 series, too slow!

[Eratanz]

I have a sheet with about 500 series of two dimensional data arranged in two columns. Each series is separated by a single empty row. I need to run a polynomial regression on each series and have the coefficients spit out, preferably in two (two coefficients) separate columns. I have little experience with Excel and doing this manually would take many hours. The regression formula is =LINEST(range, domain^{1,2},FALSE,FALSE).

Thanks in advance.

 

[Eratanz]

*kick*

 

[cigs]

Let there be two columns B and C containing your x and y data e.g
Col B Col C
1 0
9 4
5 2
7 3

You could place the line regression equation in column D somewhere for that data set. The formula is
{=LINEST((B1:B4),(C1:C4),TRUE,FALSE)}
Note that this has to be an array formula over two cells because it is going to return two coefficients m (slope) and b (offset)
To enter an array formula you have to use Shift-Ctrl-Enter together instead of the normal Enter.
Note that the third part of the formula is TRUE rather than FALSE as in your question, because you mention that you want both coefficients returned rather than have the b coefficient forced to zero.

For the other 500 series it is just a careful cut and paste job.