Hey everybody,
I am looking for help with a slope formula that will give me the slope of a range of values within a given time period. I am using it as a backup to a MIN formula to look for unexpected upward ticks in a trend that should be negatively sloped. i.e. my MIN formula would not catch an upward trend and would find the value at the beginning, making my graph look like it has bottomed-out when it actually is increasing (embarrassing observation from my PI).
I have a time column (A) and an observed values column (B). I want to set it up so that when I input the Final Time, I can automatically calculate the slope of the set of data (column B) in the range of time: "final time-30sec...final time." It doesn't need to be an accurate fit, just give me a rough trend of data so I can be aware if it is increasing unexpectedly.
Lvl 2: I don't know if this would even be an option but it would be cool to perform this function in the background as a conditional formatting for my regular MIN calculations and if (+) sloped, then highlight the corresponding cell in the same range of values.
Thank you in advance!
Bookmarks