Slope of the linear regression line
The following custom formula will return the slope of the linear regression line.
TP: = Input ("periods", 1,200,21);
((TP * (Sum (Cum (1) * C, TP )))-( Sum (Cum (1), TP) * (Sum (C, TP ))))/(( tp * Sum (Pwr (Cum (1), 2), TP))-Pwr (Sum (Cum (1), TP), 2))
Subscribe to:
Post Comments (Atom)
Popular Posts
Powered by Blogger.
No comments:
Post a Comment