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?
回答(1 个)
Guillaume
2018-2-2
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')
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!