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
 
Top