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.
Click to expand...

=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

Similar Threads

Intercept and Slope of visible rows, please. 0
Setting intercept to zero with SLOPE/STEYX/etc 3
Anomolous behaviour of slope function. 2
Excel What does E mean in excel numbers? 1
intercept graph vs. function 2
Linear Regression 8
Making your own trenlines 2
intercept and slope functions 1

Top