Question $1$

Excel worksheet W$3$Q$1$ contains a set of demographic data for different countries.

Perform hierarchical clustering analysis on this data for all of the included data columns using the 'average linkage' as clustering method and "Number of Clusters" $=3.$ Please remember to normalize your data when prompted $("$Rescale Data" $->$ "Standardization"$).$

Use the results to create one PivotTable that shows

Average Life Expectancy per cluster

Min National Income per cluster

Max $\%$ of Health Expenditures per cluster

Answer the following questions:

In this analysis, under which cluster is the United States?

What is the Average Life Expectancy, Max National Income, and Min $\%$ of Health Expenditures for the cluster that the United States are a part of$?$