K-Means, X-Means & Clustering Algorithms in VBA

[Jim]

I need a VBA sub that groups 1-dimensional data into optimal
(minimum variance) subsets.
Does anyone have VBA code for K-Means, X-Means or other Clustering
algorithms?
Thanks,
Jim

 

[gimme_this_gimme_that]

Excel has a few statistical and financial functions built into.

But generally speaking, Excel isn't the tool for the job.

Do you scientific number crunching in programming language that's
built for it.

For example, SPSS is available for Mac, and the student version is
less than $200. See: http://sfsubookstore.com/catalog/advanced_search_result.php/search_in_description/1/s/1/keywords/SPS

Use Excel for the presentation. If it has to be seamless, call Excel
via Applescript or through a shell and Applescript to stuff the data
into Excel.