LINEST - more than just the slope

  • Thread starter Thread starter JeffFinnan
  • Start date Start date
J

JeffFinnan

I have been trying to get LINEST to give more than just the slope. I went into
help and it says I should at least get slope, intercept with that comma in
between. What am I doing incorrectly?

Thanks,
Jeff
 
Each output goes into a different cell. You have to select enough cells
to hold all of the output that you want, and array enter
(Ctrl-Shift-Enter) the formula.

Jerry
 
Jeff

With Y's in C1:C10 and X's in D1:D10

select e.g. F1:G1 (two cells in a row)
and array-enter (<Shift><Ctrl><Enter>
instead of just <Enter>) the formula

=LINEST(C1:C10,D1:D10)

F1 will now hold the slope and G1 the intercept.
 
Back
Top