3-D Linear Regression

[komonoway]

Hello everyone, first post here:

I have 10 pages of data, all the same sizes of data. Basicaly, each page has 365 days of the year, with hourly temperature data for 24 hours. I want to run a linear regression through the same cell of the 10 pages. The intuitive function of : =LINEST(page1:page10!A1) doesn't work. My guess because it freaks over the lack of "x-values", which...is just laziness on microsoft's part. Anyway, does anyone know how to do this other than make one massive page of 365x24x10 numbers?

-Thanks-

[rwgrietveld]

Concatenating ranges is not possible outside VBA. I would make a simple VBA script, build an array and calculate the Sx Sx^2, Sxy, etc to make your y = a + bx.

VBA is this case is simple as all is done with Summations. A loop through all the data once and your done.

Please Login or Register  to view this content.

Note: This is no real code, but an example to give directions