Number clustering (ranges)

  • Thread starter Thread starter jgabbai
  • Start date Start date
J

jgabbai

Is it possible in excel to create a list of cluster ranges based on a
numerical dataset. In other words, if you have 20 numbers which appear
to be in clusers (10, 67, 15, 13, 70, 73) etc you get cluster ranges
such as 10-15(3 items), 67-73(3 items) etc.

Maybe this is just a (k-means?) maths problem, not an excel stats thing
- not sure...
 
Take a look at excel's help for =frequency().

It sounds like that'll work for you.
 
Thanks! Howerver, the issue is getting the right data for the
bins_array. If I don't know what the data range is, I can not define
the bins_array. Is there a way of using clustering or statistical
methods to generate the bins_array on the fly (based on the data?)
 
I guess I don't know how you would do anything if you didn't know where the data
range was.

But if it always starts in the same cell and extends down any number of cells,
you could use:

dim myRng as range
with worksheets("sheet1")
set myrng .range("b2",.range("b2").end(xldown))
end with

Then maybe you could use application.max and application.min to find the highest
and lowest in that range. Then base your bins on that.

(Yeah, I don't have a real answer! Good luck.)
 
Back
Top