Hi, thanks a lot for the appreciation. Here you have the Excel file: docs.google.com/spreadsheets/d/1gt-1sVxtX9wz1xicyjpz4_WQlQLDx2za/edit?usp=share_link&ouid=102029905910733482663&rtpof=true&sd=true
Hi Christina. If you refer to the 0 distance before the initialization, it is normal as the actual distances will be calculated during the optimization with Solver. If you refer to 0 distance after the SOLVER optimization, this means that it is right in the center of the cluster (the centroid).
very good example. would be really to have the spreadsheet live and psly with it. specially the solver
Hi, thanks a lot for the appreciation.
Here you have the Excel file:
docs.google.com/spreadsheets/d/1gt-1sVxtX9wz1xicyjpz4_WQlQLDx2za/edit?usp=share_link&ouid=102029905910733482663&rtpof=true&sd=true
Is it normal that in distance within clusters, the outcome is zero? Or is it a syntax mistake?
Hi Christina. If you refer to the 0 distance before the initialization, it is normal as the actual distances will be calculated during the optimization with Solver. If you refer to 0 distance after the SOLVER optimization, this means that it is right in the center of the cluster (the centroid).