As Part of the Quarterly Reviews, the Manager of a Retail

question 17

Essay

As part of the quarterly reviews, the manager of a retail store analyzes the quality of customer service based on the periodic customer satisfaction ratings (on a scale of 1 to 10 with 1 = Poor and 10 = Excellent). To understand the level of service quality, which includes the waiting times of the customers in the checkout section, he collected the following data on 100 customers who visited the store.



Apply k-means clustering with k = 5 using Wait Time (min), Purchase Amount ($), Customer Age, and Customer Satisfaction Rating as variables. Be sure to Normalize input data, and specify 50 iterations and 10 random starts in Step 2 of the XLMiner k-Means Clustering procedure. Analyze the resultant clusters. What is the smallest cluster? What is the least dense cluster (as measured by the average distance in the cluster)? What reasons do you see for low customer satisfaction ratings?

Understand the relationship between lifestyle habits and health.

Comprehend the impact of psychological and social factors on susceptibility to illness.

Recognize the significance of educational level on health and longevity.

Understand strategies for managing and reducing health care expenses.

---

Definitions:

Spermaceti

A waxy substance found in the head cavity of the sperm whale, historically used in candles and ointments.

Potassium Hydroxide

A strong inorganic base with the formula KOH, used in various applications including as a cleaning agent, in the manufacture of biodiesel, and in the synthesis of other chemicals.

Functional Groups

Specific groups of atoms within molecules that are responsible for the characteristic chemical reactions of those molecules.

Carboxylic Acid

Organic compounds containing a carboxyl group (-COOH), which acts as an acidic functional group.