- Customer Rating of Breakfast Cereals. The dataset Cereals.csv includes nutritional information, store display, and consumer ratings for 77 breakfast cereals.
- Apply hierarchical clustering to the data using standardized measurements (dropping the mfr and type column because they are non-numerical).
- Create a Dendrogram of the clusters, as well as put colored boxed around the dendgram clusters (2,3,4,5), at different levels. Which cereals are in cluster 5?
- What's your interpretation of the result? Any reasonable solutions are accepted here.
200 1 14 25 3 0.75 34.384843 R C 110 2 2 8 and_Delight 10 70 25 0.75 29.509541 110 1.5 G C 180 10.5 _Cinnamon_Cheerios 25 2 1 33.174094 C 125 11 14 110 2 0 1 e_Jacks K 25 3 0.75 37.038562 18 8 100 1.33 G C 130 3 210 : 4 1 1 0.67 49.120253 C 90 2 1 200 4 15 6 125 25 R _Chex 190 25 3 1 0.67 53.313813 P C 90 3 0 210 5 13 5 _Flakes 12 12 35 25 1 0.75 18.042851 0 Q C 120 1 220 'Crunch 17 1 105 25 1 1 1.25 50.764999 G C 110 6 2 290 2 erio 45 25 2 1 0.75 19.823573 G C 120 1 3 210 0 13 9 amon_Toast_Crunch 25 3 1 0.5 105 40.400208 7 G C 110 3 140 2 13 ters 2 1 22.736446 0 12 13 55 25 1 G C 110 1 1 180 a_Puffs 25 25 1 1 41.445019 22 3 R C 110 2 0 280 0 Chex 25 1 45.863324 1 21 2 35 1 K C 100 0 290 _ Flakes 1 13 12 20 25 2 1 1 1 35.782791 90 K C 110 1 Pops 13 35 25 2 1 22.396513 1 1 180 0 12 t_Chocula G C 110 0.5 40.448772 3 4 10 7 160 25 3 1 110 140 klin'_Oat_Bran K C 3 1 1 64.533816 0 0 2 N H 100 3 0 80 1 21 m_of_Wheat_(Quick) 3 1 46.895644 0 220 1 21 3 30 25 K C 110 2 11 10 120 25 3 1 0.75 36.176196 C 100 2 1 140 by_Wheat_&_Raisins G 5 BO 25 w 1 0.75 44.330856 1 18 R C 100 0 190 le_Chex 2 1 32.207582 1 11 13 30 25 K C 110 1 125 t_Loops 0.75 31.435973 1 11 25 1 14 25 1 K C 110 1 0 200 ted_Flakes 100 25 2 0.8 58.345141 14 7 C 100 0 K 3 0 3 ted_Mini-Wheats 200 25 w 1.25 0.67 40.917047 C 120 3 2 160 5 12 10 &_Fibre_Dates,_Walnuts,_and_Oats P 75 3 1.33 5 14 17 190 0.67 41.015492 K C 120 3 0 240 ful_Bran 2 1 0.75 28.025765 1 1 135 0 13 12 25 25 P C 110 _Pebbles 15 40 25 1 1 0.88 35.252444 11 P C 2 0 0 100 45 en_Crisp 45 25 0.75 23.804043 280 15 9 en_Grahams G C 110 1 25 3 1 5 85 0.88 52.076897 P C 100 3 1 140 3 15 _Nuts_Flakes 90 25 3 1 0.25 53.371007 P C 110 3 0 170 3 17 3 e-Nuts 25 3 1 0.33 45.811716 13 4 100 C 120 3 3 75 3 t_Grains_Pecan P 1 12 11 45 25 2 1 1 21.871292 C 1 220 Q 120 2 ey_Graham_Ohs 11.5 10 90 25 1 0.75 31.072217 G C 110 W 250 1.5 y_Nut_Cheerios 1.33 28.742414 35 25 1 1 P C 110 1 0 180 0 14 11 y-comb 3 1 36.523683 1 17 6 60 100 K 110 2 1 170 Right_Crunchy_Nuggets C 0.75 36.471512 9 95 100 3 1.3 K C 140 3 1 170 20 Right_Fruit_&_Nut 40 25 1 1.5 39.241114 G C 110 2 1 260 0 21 3 95 25 2 1 0.67 45.328074 100 4 2 12 6 Q C 150 2 12 12 55 25 1 26.734515 G C 110 1 180 _Charms 3 95 25 1 1 54.850917 A H 4 1 16 100 0 0 3 1 1 37.136863 3 16 11 170 25 li_Raisins,_Dates,_&_Almonds R C 150 4 3 95 3 16 11 170 25 3 34.139765 R 150 4 3 150 li_Raisins,_Peaches,_&_Pecans C 13 160 25 3 1.5 0.67 30.313351 3 2 150 3 17 lix_Crispy_Blend K C 160 25 1 15 6 90 1 40.105965 1 Grain_Cheerios G C 100 220 9 10 25 2 1 0.67 29.924285 C 2 190 0 15 K 120 1 Honey_Crunch w 220 3 21 7 130 25 1.33 0.67 40.69232 C 3 2 -Grain_Almond-Raisin K 140 25 3 59.642837 3 3 2 170 18 K C ar -grain_Wheat 120 25 3 1.25 0.5 30.450843 G C 130 3 2 170 1.5 13.5 10 real_Raisin_Crisp