LINEST - more than just the slope

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
 
J

Jerry W. Lewis

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
 
L

Leo Heuser

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linear Regression 8
Regression with zero intercept 2
Gradient and intercept on data with errors 2
Accessing individual elements of an array returned by a function 1
LINEST - supposedly same calculations but different RSQ-values. 0
optimization 1
Setting intercept to zero with SLOPE/STEYX/etc 3
Linest/slope functions with with different data ranges 1

Top