Your boss is wondering what youve been doing in class this week. Write a one page, single spaced report that explains the cluster analysis using excel so far. Describe the steps in detail such that your layman boss will understand. Include one example of cluster analysis that is not covered in the class. End your report with a detailed analysis of the clusters you found for the problem.

Here is the cluster excel

Offer #	Campaign	Varietal	Minimum Qty (kg)	Discount (%)	Origin	Past Peak	Cluster 1	Cluster 2	Cluster 3	Cluster 4
1	January	Malbec	72	56	France	FALSE	0.00973071	0.00458872	0.08217531	0.12611454
2	January	Pinot Noir	72	17	France	FALSE	0.00477048	0.00482149	0.19026024	0.05006503
3	February	Espumante	144	32	Oregon	TRUE	0.03754108	0.04881757	0.00161386	0.17332588
4	February	Champagne	72	48	France	TRUE	0.05413401	0.03130258	0.0994802	0.20585898
5	February	Cabernet Sauvignon	144	44	New Zealand	TRUE	0.00709017	0.01535229	0.07551512	0.03726857
6	March	Prosecco	144	86	Chile	FALSE	0.04559319	0.00874335	0.06048878	0.29575563
7	March	Prosecco	6	40	Australia	TRUE	0.00258204	0.75393793	0.02216408	0.09344826
8	March	Espumante	6	45	South Africa	FALSE	0.99397606	0.10289668	0.00182467	0.09031225
9	April	Chardonnay	144	57	Chile	FALSE	0.01893511	0.00802983	0.16961234	0.06724188
10	April	Prosecco	72	52	California	FALSE	0.04384037	0.0612413	0.0350287	0.06669208
11	May	Champagne	72	85	France	FALSE	0.00537476	0.00349677	0.1013826	0.29765605
12	May	Prosecco	72	83	Australia	FALSE	0.00442396	0.04304416	0.05167148	0.10591563
13	May	Merlot	6	43	Chile	FALSE	0.10441201	0.16463481	0.00489883	0.00613723
14	June	Merlot	72	64	Chile	FALSE	0.00324154	0.00300687	0.09517407	0.13815543
15	June	Cabernet Sauvignon	144	19	Italy	FALSE	0.01264129	0.00706435	0.03922654	0.13481201
16	June	Merlot	72	88	California	FALSE	0.01163146	0.00407627	0.07024183	0.02946495
17	July	Pinot Noir	12	47	Germany	FALSE	0.00516017	0.01160986	0.18991765	0.00733384
18	July	Espumante	6	50	Oregon	FALSE	0.17415068	0.34266075	0.03460768	0.055727
19	July	Champagne	12	66	Germany	FALSE	0.00457076	0.02857979	0.0234201	0.10441882
20	August	Cabernet Sauvignon	72	82	Italy	FALSE	0.00710587	0.0125824	0.0376005	0.0868599
21	August	Champagne	12	50	California	FALSE	0.00279161	0.00589412	0.04110829	0.07467653
22	August	Champagne	72	63	France	FALSE	0.01307368	0.01297356	0.00400381	0.86470645
23	September	Chardonnay	144	39	South Africa	FALSE	0.00874589	0.00811433	0.06943331	0.0573672
24	September	Pinot Noir	6	34	Italy	FALSE	0.00760142	0.00407131	0.3393066	0.01408852
25	October	Cabernet Sauvignon	72	59	Oregon	TRUE	0.00900165	0.00435581	0.06839621	0.06950012
26	October	Pinot Noir	144	83	Australia	FALSE	0.00728875	0.00871197	0.31678656	0.02943023
27	October	Champagne	72	88	New Zealand	FALSE	0.06740493	0.00876529	0.08024978	0.14632658
28	November	Cabernet Sauvignon	12	56	France	TRUE	0.00521609	0.0297757	0.05299502	0.11404892
29	November	Pinot Grigio	6	87	France	FALSE	0.23688903	0.58309613	0.02534337	0.03428599
30	December	Malbec	6	54	France	FALSE	0.21137513	0.55591501	0.04511415	0.14094192
31	December	Champagne	72	89	France	FALSE	0.04716266	0.03179509	0.0949088	0.42180785
32	December	Cabernet Sauvignon	72	45	Germany	TRUE	0.00482307	0.00793334	0.04143611	0.08240601
						Distance to Cluster 1
Total Distance						Distance to Cluster 2
143.140668						Distance to Cluster 3
						Distance to Cluster 4
						Minimum Cluster Distance
						Assigned Cluster