Question

1 Approved Answer

Posted on Jul 12, 2024

Use Analytic Solver to perform k- means clustering on the accompanying data set. Use variables x1, x3, and xg in the analysis. Do not standardize

image text in transcribed

Use Analytic Solver to perform k- means clustering on the accompanying data set. Use variables x1, x3, and xg in the analysis. Do not standardize the variables. pictureClick here for the Excel Data File a. Set the number of clusters to 3. What are the size and cluster center values for the largest cluster? (Round your answers to 2 decimal places.) Size of the largest cluster Cluster center value of x 1 Cluster center value of X3 Cluster center value of X5 b. Perform the same analysis as in part a, but with variables standardized to z-scores. What are the size and cluster center values for the largest cluster? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Size of the largest cluster Cluster center value of x1 Cluster center value of X3 Cluster center value of X5 D 11 G X4 7.8 1.6 NE 2.4 NWT 3 5.1 3.2 2.5 9 2.4 2.6 2.9 4 3.6 3.3 6.1 5.9 2.4 NNN TOONOLO OM PP x1 539670000 764870000 520660000 562880000 556770000 307170000 482260000 723410000 398690000 471220000 82490000 286010000 381480000 208790000 59350000 275880000 137930000 248410000 308850000 426420000 170630000 160790000 267270000 184910000 73060000 6180000 126520000 3420000 138770000 217710000 230630000 154590000 105220000 67940000 86770000 37400000 170020000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 B x2 x3 29.1 1880000 9.5 29650000 13.5 2819000 13.4 7419000 27.3 3553000 15.7 7058000 25.2 11440000 3 564000 30.9 8175000 4.2 7413000 51.1 9484000 7.4 5157000 0.3 8375000 25.7 3634000 31.3 7388000 28.1 243000 35.1 1034000 10.5 2555000 7.3 2909000 23.4 7642000 10.3 15237000 6.1 4322000 22.6 4979000 9.8 933000 35.3 1478000 153.5 638000 14.1 945000 49.5 1793000 26 1484000 9 4498000 74934000 15.6 4959000 40.6 1266000 21.3 3085000 9.3 319000 86.1 2208000 10.3 479000 too NLO TOTO H L. NNNNON O LOLOT F x6 140 126 460 107 209 136 135 217 80 78 102 131 139 255 36 797 402 402 153 01PWNNNUT O W W 2.1 E x5 7.9 1.6 2.5 3 4.9 3.1 2.6 8.5 22 2.5 2.3 3.4 3.5 2.5 6.4 5.8 1.9 2 4.1 4.6 1 1.3 5.6 15.5 3.8 1.6 5.3 1.1 1.5 3.1 6 2.5 2.2 3.5 5 1.3 2.3 00 WE UW 01 01 WNN NP 2.7 3.2 1.3 1.4 5.7 14.2 4 2.9 5.3 1.2 2.8 3 6.1 2.2 2.4 3.5 5 80 NPOIN 141 191 68 162 129 373 155 337 808 127 66 155 121 140 162 126 1614 W 1.4 2.3 Use Analytic Solver to perform k- means clustering on the accompanying data set. Use variables x1, x3, and xg in the analysis. Do not standardize the variables. pictureClick here for the Excel Data File a. Set the number of clusters to 3. What are the size and cluster center values for the largest cluster? (Round your answers to 2 decimal places.) Size of the largest cluster Cluster center value of x 1 Cluster center value of X3 Cluster center value of X5 b. Perform the same analysis as in part a, but with variables standardized to z-scores. What are the size and cluster center values for the largest cluster? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Size of the largest cluster Cluster center value of x1 Cluster center value of X3 Cluster center value of X5 D 11 G X4 7.8 1.6 NE 2.4 NWT 3 5.1 3.2 2.5 9 2.4 2.6 2.9 4 3.6 3.3 6.1 5.9 2.4 NNN TOONOLO OM PP x1 539670000 764870000 520660000 562880000 556770000 307170000 482260000 723410000 398690000 471220000 82490000 286010000 381480000 208790000 59350000 275880000 137930000 248410000 308850000 426420000 170630000 160790000 267270000 184910000 73060000 6180000 126520000 3420000 138770000 217710000 230630000 154590000 105220000 67940000 86770000 37400000 170020000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 B x2 x3 29.1 1880000 9.5 29650000 13.5 2819000 13.4 7419000 27.3 3553000 15.7 7058000 25.2 11440000 3 564000 30.9 8175000 4.2 7413000 51.1 9484000 7.4 5157000 0.3 8375000 25.7 3634000 31.3 7388000 28.1 243000 35.1 1034000 10.5 2555000 7.3 2909000 23.4 7642000 10.3 15237000 6.1 4322000 22.6 4979000 9.8 933000 35.3 1478000 153.5 638000 14.1 945000 49.5 1793000 26 1484000 9 4498000 74934000 15.6 4959000 40.6 1266000 21.3 3085000 9.3 319000 86.1 2208000 10.3 479000 too NLO TOTO H L. NNNNON O LOLOT F x6 140 126 460 107 209 136 135 217 80 78 102 131 139 255 36 797 402 402 153 01PWNNNUT O W W 2.1 E x5 7.9 1.6 2.5 3 4.9 3.1 2.6 8.5 22 2.5 2.3 3.4 3.5 2.5 6.4 5.8 1.9 2 4.1 4.6 1 1.3 5.6 15.5 3.8 1.6 5.3 1.1 1.5 3.1 6 2.5 2.2 3.5 5 1.3 2.3 00 WE UW 01 01 WNN NP 2.7 3.2 1.3 1.4 5.7 14.2 4 2.9 5.3 1.2 2.8 3 6.1 2.2 2.4 3.5 5 80 NPOIN 141 191 68 162 129 373 155 337 808 127 66 155 121 140 162 126 1614 W 1.4 2.3