Fitting to power law to the data sets of different lengths in excel....

[drniranjan]

Hi all,
I have data sets of X and Y arranged in rows. the first half coulmn data is the X and remaining half coulmns data are the Y..likewise, every row has even number of columns of which 1st half is the X and second half is the Y...

For example, I have data sets like

2 3 4 5 6 7 12 34 32 56 12 11
1 3 2 4 9 6 11 23 12 45 12 12
1 5 5 12 21 45
2 6 7 8 22 43 56 11

please note that length of X and Y pairs are not same for all rows .......
as shown in the above example set say for 1st row, 1st six values are X and remaining six values are Y...this follows for every row......

I need to fit these data sets using power law and to return only R2 (fittting coefficient) of the fitting...
Can anyone come up with either macro or any formuale so that I can calculate the R2 for all rows........I have thousands of rows of data sets like above pattern.

Your expertise and quick reply will be higly appreciated.......

best regards, Niranjan