Basic histogram with histogram function.
显示 更早的评论
I am trying to create a histogram from a data set in excel by importing it to matlab.
I can't get the histogram function to work with a table or data array after import.
I need to use the data set to make a histogram with a bin width of 50 and then subtract one entry per bin.
how do I reference the array or table in the histogram function? how would I subtract one entry per bin?
any help would be greatly appreciated.
3 个评论
Ameer Hamza
2020-5-14
Can you share a sample dataset? The correct solution depends on how your data is arranged.
daniel caltrider
2020-5-15
daniel caltrider
2020-5-15
采纳的回答
Ameer Hamza
2020-5-15
编辑：Ameer Hamza
2020-5-15
To decrease, one entry per bin, try this
[num,~,~]=xlsread('histogram2.xlsx');
d=num;
h = histogram(d,50);
h.BinCounts = h.BinCounts-1
9 个评论
daniel caltrider
2020-5-15
编辑：daniel caltrider
2020-5-15
daniel caltrider
2020-5-15
Ameer Hamza
2020-5-15
Which MATLAB release are you using? Can you paste your lines of code here?
daniel caltrider
2020-5-15
Ameer Hamza
2020-5-15
No, I meant to attach the code which gives error about BinCounts. Can you change your code according to my answer, run it and then paste the code and error message?
daniel caltrider
2020-5-15
Ameer Hamza
2020-5-15
Ok. The error is caused because if the height of the histogram for some bins is zero, then subtracting 1 will make it negative (which does not make any sense). Therefore try the following line. It leaves the bins with zero height
h.BinCounts(h.BinCounts>0) = h.BinCounts(h.BinCounts>0)-1
daniel caltrider
2020-5-15
Ameer Hamza
2020-5-15
I am glad to be of help!
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Histograms 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
