How to count the given data range and calculate cumulative sum of given data and plot it?

4 次查看（过去 30 天）

sam moor 2017-3-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/327559-how-to-count-the-given-data-range-and-calculate-cumulative-sum-of-given-data-and-plot-it

评论： John Chilleri 2017-3-2

data.xls

I have excel data as attached below. I want to have sf(data.xls) range as 0-0.05,0.05-0.1, 0.1-0.15,0.15-0.2....and so on. Now, 2nd column of data represents number that have corresponding sf (num). I want to start counting the num(data.xls) that falls within sf range (0-0.05, 0.05-0.1,...) using count=1, and do cumulative of sf range and would like to put in array. Finally, I want to plot sf(0,0.05,0.1,0.15...) vs cumulative sum. Let me know your suggestion. I used count function but giving me error. Thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

John Chilleri 2017-3-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/327559-how-to-count-the-given-data-range-and-calculate-cumulative-sum-of-given-data-and-plot-it#answer_256857

编辑：John Chilleri 2017-3-1

在 MATLAB Online 中打开

Hello,

If I understand your question correctly, then this might help:

data = xlsread('data.xls');
sf = (0:.5:2.5)';
cumsum_sf = zeros(length(sf),1);
for i = 1:length(sf)
   cumsum_sf(i) = numel(find(data(:,1)<=sf(i)))-sum(cumsum_sf);
end
plot(sf, cumsum_sf)

This is just an idea of how to go about it, you can always set up a loop and count if it's greater than blah and less than blah+.05.

Hope this helps!

4 个评论
显示 2更早的评论隐藏 2更早的评论

sam moor 2017-3-1

This works great. Is there any function in matlab to put sf and cumsum_sf in two column side by side(creating new name) so that i can see how many number pass sf value?

John Chilleri 2017-3-2