Login Page - Create Account

Support Board


Date/Time: Fri, 27 Jan 2023 08:49:30 +0000



Post From: Need Example of SLOPE Function for Spreadsheet Column K-X formulas

[2016-03-11 18:24:27]
tomgilb - Posts: 3539
I never followed up on that old post. What I was wondering is: Is an MA the KnownY or the KnownX ?
It's true that two ranges are required, but which is which?

Try this:
=-SLOPE(A3:A12,B3:B12)
where:
-the Open is in column B is used as the KnownX
-the time stamp in column A is used as the KnownY
-the polarity is reversed with a preceding '-' because column A is in descending order.