I have a question

I have bucket bounds from -98% to +100% and the no of observations are 41 from Excel.I want calculate how many of these observations occur from my data: =COUNTIFS(my data,"<"&$C56,my data,">="&$C55)/COUNT(my data). How do I do this in MatLab?

Answer 1

[Guillaume]

If there's only one bucket you're interested in then,

sum(mydata >= lowerlimit & mydata < upperlimit) / numel(mydata)

If you're interested in more than one bucket then you can do it all at once for all the buckets with:

histcounts(mydata, yourbucketedges, 'Normalization', 'probability')

[Siphiwo Nqangase]

Thanks for your answer, I used "histcounts" and it worked.