MATLAB: How to create binEdges

Question

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

Answer 1

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.