How do you find centroid values for each cluster using the excel data mining plug-in (or SQL Server 2008)? In particular, how can the centroids be measured accurately when their vectors include nominal and boolean values?
I've read the online books and I only got as far as node_distribution. I'm looking for centroid values or an algorithm to find values that I can plug into a distance equation outside of sql server.