# find the lowest value in a selection of data

2 views (last 30 days)
C.G. on 21 Oct 2021
Edited: Scott MacKenzie on 21 Oct 2021
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;
C.G. on 21 Oct 2021
ok i understand that, how would I get the value of column 5 which also equates to this?

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
##### 1 CommentShowHide None
C.G. on 21 Oct 2021
Thank you that’s great

### Community Treasure Hunt

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

Start Hunting!

Translated by