Data Analytics Video Exercises

"Do you want an original answer to this question?


Yes No

Step 1. Watch the following video.

Step 2. Open both the “cluster” excel file and the “pizza dataset” excel file.

Step 3. Copy the Taste through Serve data (cells C2: J101) from the pizza dataset excel file into the datafields in the cluster excel file.

Step 4. Run the cluster analysis tool (click on where it says ‘click to run cluster analysis’…located around cell B10)

Step 5. Find the new cluster scores (on the “output clusters” sheet) and copy it back to the pizza dataset putting it in an empty column and label it “segment” on the row that has the names of variables. (Hint: Looking for either a 4 cluster or 5 cluster solution)

Step 6. Save the workbook and upload it.

attachment
hansen-pizzadataset.xlsx