slope function

L

Luke

I wish to calculate the slope ( linear) using the =slope
(x,y) and force the intercept to zero.

I can do this using the graph, options and set intercept
to zero but I wish to do it using the formula.

Thanks.
 
R

Ron Rosenfeld

I wish to calculate the slope ( linear) using the =slope
(x,y) and force the intercept to zero.

I can do this using the graph, options and set intercept
to zero but I wish to do it using the formula.

Thanks.

=LINEST(known-y's,known-x's,FALSE)


--ron
 

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

Top