Question: please make this in excel Distance to Centroid Calculation for Wine Clusters. Jay Gatsby categorizes wines into one of three clusters. The centroids of these

please make this in excel
Distance to Centroid Calculation for Wine Clusters. Jay Gatsby categorizes wines into one of three clusters. The centroids of these clusters, describing the average characteristics of a wine in each cluster, are listed in the following table.
Characteristic Cluster 1 Cluster 2 Cluster 3 Alcohol 0.8190.164-0.937 Malic Acid -0.3290.869-0.368 Ash 0.2480.186-0.393 Alkalinity -0.6770.5230.249 Magnesium 0.643-0.075-0.573 Phenols 0.8250.977-0.034 Flavanoids 0.896-1.2120.083 Nonflavanoids -0.595
Proanthocyanins 0.619-0.7780.010 Color Intensity 0.1350.939-0.881 Hue 0.497-1.1620.437 Dilution 0.744-1.2890.295 Proline 1.117-0.406-0.776
Jay has recently discovered a new wine from the Piedmont region of Italy with the following characteristics. In which cluster of wines should he place this new wine? Justify your choice with appropriate calculations.
 please make this in excel Distance to Centroid Calculation for Wine

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!