Using the Data Given, Apply Hierarchical Clustering with 5 Clusters

question 25

Essay

Using the data given, apply hierarchical clustering with 5 clusters using Wait Time (min), Purchase Amount ($),
Customer Age, and Customer Satisfaction Rating 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 five clusters
in the hierarchical clustering.
b. Identify the cluster with the largest average waiting time. Using all the variables, how would you characterize
this cluster?
c. Identify the smallest cluster.
d. By examining the dendrogram on the HC_Dendrogram worksheet (as well as the sequence of clustering stages
in HC_Output1), what number of clusters seems to be the most natural fit based on the distance?

---

Definitions:

Psychologists

Professionals specializing in studying the mind and behavior, often providing counseling and therapy services.

Psychiatrists

Persons trained in medicine prior to doing specialized training in dealing with mental illness. This specialized training focuses on diagnosis and medical treatment that emphasize the use of pharmacological agents in managing mental disorders. Most psychiatrists attend to the medical aspects and biological foundations of these disorders, although they usually also consider psychological and environmental influences.

Psychosis Diagnosis

The identification of a mental disorder in which there is a disconnection from reality, marked by delusions, hallucinations, or disordered thinking.

Ethical Principles

Fundamental concepts that guide moral conduct, such as autonomy, beneficence, nonmaleficence, and justice, especially in fields like healthcare and research.