Assignment:
Step 1. Review the following youtube video.
Market Segmentation Part 1 - Using Cluster Analysis to Create Market Segments
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)
Attachment:- pizza dataset.xlsx