How do I determine which row my value change significantly
6 views (last 30 days)
I'm looking to automate the process of finding where my column data changes from 375 (about the first 7 rows right now), as it starts decreasing constantly after that. Depending on the data loaded in, the change from a constant 375 can start anywhere from row 3 to row 8, so I'd like to detect where it begins. Thanks!
More Answers (1)
TADA on 26 Nov 2019
Im assuming its roughly 375 and not exactly that value, otherwise go with Turlough Hughes' solution which is simpler.
The easiest method is to compare the values with tolerance to changes. You can define a threshold value that you would concider as significant reduction
% for the sake of this example I'm using 5% of the initial value (should be ~5% of 375)
threshold = 0.05*data(1);
sigDecMask = data < (data(1) - threshold);
startDecIdx = find(sigDecMask, 1, 'first');