find the lowest value in a selection of data

2 views (last 30 days)
I have a matrix of data where I am working with columns 5 and 6. I have divided the data into sections based on the values of column 5.
Now for each of the variables S1-S4, I want to find the lowest value of column 6 that occurs in each variable, and save both the values in columns 5 and 6 that correpsond to this and plot the values on a graph.
S1 = T(:,5) >0.13;
S2 = T(:,5)>= 0.115 & T(:,5) <= 0.129;
S3 = T(:,5)>= 0.1 & T(:,5) <= 0.114;
S4 = T(:,5)>= 0.084 & T(:,5) <= 0.09;
  4 Comments
Scott MacKenzie
Scott MacKenzie on 21 Oct 2021
Edited: Scott MacKenzie on 21 Oct 2021
Your variables S1 through S4 are logical vectors. They contain 1s in positions corresponding to the items of interest in column 5. You can use these variables to retrieve the corresponding minimum values in column 6. As an example, for the logical vector S1, the minumum corresponding value in column 6 is
min(T(S1,6))
C.G.
C.G. on 21 Oct 2021
ok i understand that, how would I get the value of column 5 which also equates to this?

Sign in to comment.

Accepted Answer

Scott MacKenzie
Scott MacKenzie on 21 Oct 2021
Edited: Scott MacKenzie on 21 Oct 2021
[m, idx] = min(T(S1,6)); % minimum value in column 6, as per S1
x = T(idx,5); % value in column 5 at same location/row

More Answers (0)

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!