topic Find the max slope in Discussions

Find the max slope

Erez — Sun, 11 Jun 2023 12:14:24 GMT

Hello everyone,

I have a list of points forming a slanted line, I am interested in knowing the maximum slope created by the curve.

I have a lot of sets of points so I'm interested in knowing how to do it in a formula.

For example, the numbers 1,2,3,4 form a straight line with a fixed slope of 1 so the max is 1. My numbers don't form a straight line so the equation is more complicated.

Attach a sample file.

Thanks.

Re: Find the max slope

Craige_Hales — Thu, 27 Oct 2022 11:28:11 GMT

If the slopes are within each row, maybe this

Capturing the maximum change between columns.

You might care about absolute value of the change. Abs(point3-point2) ...

You might need a scalable design, handling 100s of columns. That's possible using an array.

Re: Find the max slope

Mark_Bailey — Thu, 27 Oct 2022 13:03:19 GMT

Are you fitting a model and extracting the maximum first derivative, or are you just interested in the most significant difference between points?

Re: Find the max slope

Erez — Thu, 27 Oct 2022 13:13:01 GMT

I interested in the most significant difference between points.

That's why Craige_Hales' solution is good for me.

Thanks.

Re: Find the max slope

txnelson — Thu, 27 Oct 2022 13:39:11 GMT

Here is a modification to @Craige_Hales formula that removes the requirement to list each pair of columns

dt = Current Data Table();
Max( Abs( dt[Row(), Index( 1, N Cols( dt ) - 2 )] - dt[Row(), Index( 2, N Cols( dt ) - 1 )] ) );

Re: Find the max slope

Mark_Bailey — Thu, 27 Oct 2022 14:22:18 GMT

Here is a different approach using a script. It accommodates any number of data points (data columns) and observations. It assumes that the data table is open and that the last column is dedicated to storing the result.