Finding the ratio of numbers in an array

5 次查看(过去 30 天)
I access my array as:
data{1, i}(:,2)
So it is in the second column of data{1,i}
I have data in columns 3 and 4 already. I would like to make a column 5. I want column 5 to be the value in column 2 divided by the value in column 2 but 30 cells up. This means the first 30 values cannot be defined since we cannot compare to 30 cells prior. I keep trying this but I either get an array of zeros, or a single value. Can anyone help?
For instance, this does not work:
for j =31:1:1000
rois=data{1, i}(j,2)/data{1, i}(j-30,2)
end
  2 个评论
Benjamin Cowen
Benjamin Cowen 2020-3-4
编辑:Benjamin Cowen 2020-3-4
Yeah, it should be 1, sorry about that. I tried 1 at first and it got hung, so i assumed i was doing something wrong

请先登录,再进行评论。

回答(1 个)

Rik
Rik 2020-3-4
编辑:Rik 2020-3-4
rois=data{1, i}(31:end,2)./data{1, i}(1:(end-30),2);
In your current loop you are overwriting your result every iteration, you should have used indexing instead, skip the loop entirely.

类别

Help CenterFile Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by