The third argument should be left empty as setting it can force the model to not use an intercept, which is almost always a bad idea. The second argument is the array of predictor variables (X1,X2). The first argument is the outcome variable data points (Y). Go to the formula bar and type the LINEST command, for example =LINEST(A2:A100,B2:C100,TRUE).
0 Comments
Leave a Reply. |