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).
I still did not understand how you would plot the data? Can you show, how you created the graph somewhere?
yes same question from my side also
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).