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.
MATLAB: How to count the given data range and calculate cumulative sum of given data and plot it
arraycountcumulativedataexcelrangesum
Best Answer