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:

Spending Variance

The difference between the actual amount spent and the budgeted amount for a particular account or category.

Supply Costs

Expenses incurred in acquiring the goods or services needed to run a business, including raw materials, parts, and utilities.

Spending Variance

The difference between the actual amount spent and the amount that was budgeted for a particular period.

Square Feet

A unit of area measurement equal to a square that is one foot on each side, commonly used in real estate and interior planning.