Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. Customer Rating of Breakfast Cereals. The dataset Cereals.csv includes nutritional information, store display, and consumer ratings for 77 breakfast cereals.
  2. Apply hierarchical clustering to the data using standardized measurements (dropping the mfr and type column because they are non-numerical).
  3. 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?
  4. What's your interpretation of the result? Any reasonable solutions are accepted here.
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting An Introduction to Concepts Methods and Uses

Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil

10th Edition

1111822239, 324639767, 9781111822231, 978-0324639766

More Books

Students also viewed these Accounting questions

Question

Explain CRM and how it relates to database marketing.

Answered: 1 week ago

Question

describe the key elements of work;

Answered: 1 week ago