to computer Coefficent of determination for thousands of row having different length of data sets

[drniranjan]

Hi,
Say, I have the data sets like.....
12 32 33 45 13 33 12 22 12 32 33 45 13 33 12 22
12 32 33 45 13 33
12 32 33 45 13 33 12 22 12 32
..........................
.............................

many more rows............

half of the cells in any row are having X-data and remaining half data are the Y.. I am fitting power law to get the fitting coefficient (coeff. of determination) between X and Y for all rows...........

for this I am using following formula:

INDEX(LINEST(LN(RC[1]:RC[8]),LN(RC[9]:RC[16]),TRUE,TRUE),3,1)

for 1st row, it is working ..FOR next and remaining rows.........While i am autofilling, the formula is not working..........means the number '8' and other numbers are not changing automatically based on the actual length of X-Y pairs.....

kindly help me out or suggest any macro.........so that this can be solved within minuties with less manual effort.......................


Best, N
<!-- / message -->