find the lowest value in a selection of data

3 vues (au cours des 30 derniers jours)
C.G.
C.G. le 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;
  4 commentaires
Scott MacKenzie
Scott MacKenzie le 21 Oct 2021
Modifié(e) : Scott MacKenzie le 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. le 21 Oct 2021
ok i understand that, how would I get the value of column 5 which also equates to this?

Connectez-vous pour commenter.

Réponse acceptée

Scott MacKenzie
Scott MacKenzie le 21 Oct 2021
Modifié(e) : Scott MacKenzie le 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 commentaire
C.G.
C.G. le 21 Oct 2021
Thank you that’s great

Connectez-vous pour commenter.

Plus de réponses (0)

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by