I have ~144K rows of data and need help tweaking the LINEST function to run multiple regression against my data structure.
On a single row, there are 3 columns with X1 variable results, 3 columns with X2 variable results, and 3 columns with Y results.
The formula I am trying to use to get X1 and X2 slopes and the intercept is:
{=LINEST(G1:I1,(A1:C1,D1:F1))}
The problem is splitting the "Known X's" (A1:C1 and D1:F1) so the function recognizes it as two separate sets of variables.
Any suggestions?? Thank you very much in advance for the help.
On a single row, there are 3 columns with X1 variable results, 3 columns with X2 variable results, and 3 columns with Y results.
The formula I am trying to use to get X1 and X2 slopes and the intercept is:
{=LINEST(G1:I1,(A1:C1,D1:F1))}
The problem is splitting the "Known X's" (A1:C1 and D1:F1) so the function recognizes it as two separate sets of variables.
Any suggestions?? Thank you very much in advance for the help.
