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:

Competency

The combination of knowledge, skills, and behaviors that is required for effective performance in a given role or job.

Collective Learning

The process by which a group acquires knowledge and skills through shared experiences, leading to improvement in performance or understanding.

Outsourcing

The business practice of hiring external parties to perform services or create goods that traditionally were performed in-house by the company's own staff.

Standards of Service

Benchmarks set by an organization to measure the quality of service delivered to its customers, ensuring consistency and satisfaction.