How can I create binEdges?
3 views (last 30 days)
Show older comments
I have the Data below and I want to create bins that vary from the lowest to the highest value of the Data(:,2) and I am using
the code as following but I get bins with zero members and that is not what I want.
First:
How can I create a set of bins that have always more than two members on it?
Second:
How to use the same binEdges but binning the first 150 values of the Data(:,2) with more than 2 members per bin?? And then doing the same thing and same binEdges but using the second 150 values of the Data(:,2)??
price=Data(:,1);
topEdge1=max(Data(:,2));
botEdge1=min(Data(:,2));
NumBins=30;
binEdges1=linspace(botEdge1, topEdge1, NumBins);
[h, WhichBin]= histc(Data(:,2),binEdges1);
for i = 1:Numbin
BinMembers=(WhichBin==i);
binMembers=price(BinMembers);
binMean1(i)=mean(binMembers);
binstd1(i)= std(binMembers);
end
0 Comments
Accepted Answer
J. Alex Lee
on 12 Mar 2020
It looks like your problem is not with binning, but the fact that you have NaN's in your data.
By the way if you have 2014b or later, probably better to switch to histcounts.
2 Comments
J. Alex Lee
on 12 Mar 2020
Look for NaN's in your data. As I said, your problem is not with binning.
More Answers (0)
See Also
Categories
Find more on Data Distribution Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!