Using the Data Given, Apply Hierarchical Clustering with 10 Clusters

question 49

Essay

Using the data given, apply hierarchical clustering with 10 clusters using LandValue ($), BuildingValue ($), Acres, Age, and Price ($) as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Use Ward's method as the clustering method.
a. Use a PivotTable on the data in the HC_Clusters1 worksheet to compute the cluster centers for the clusters in the
hierarchical clustering.
b. Identify the cluster with the largest average price. Using all the variables, how would you characterize this cluster?
c. Identify the smallest cluster.

---

Definitions:

Sales Calls

The act of contacting potential customers directly, typically via telephone or in person, to introduce a product or service with the aim of making a sale.

Sales Call Objective

The goal or desired outcome of a communication or meeting with a potential client in sales.

Directly Beneficial

refers to actions, goods, or services that provide immediate advantages or positive effects to an individual or group.

Planning

The process of defining objectives, developing strategies, and outlining tasks and schedules to achieve the goals of an individual or organization.