Using the data given, apply k-means clustering using Wait time (min) as the variable with k = 3. Be sure to Normalize input data, and specify 50 iterations and 10 random starts in Step 2 of the XLMiner k-Means Clustering procedure. Then create one distinct data set for each of the three resulting clusters for waiting time
a. For the observations composing the cluster which has the low waiting time, apply hierarchical clustering with Ward’s method to form two clusters using 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. Using a PivotTable on the data in HC_Clusters, report the characteristics of each cluster.
b. For the observations composing the cluster which has the medium waiting time, apply hierarchical clustering with Ward’s method to form three clusters using 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. Using a PivotTable on the data in HC_Clusters, report the characteristics of each cluster.
c. For the observations composing the cluster which has the high waiting time, apply hierarchical clustering with Ward’s method to form two clusters using 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. Using a PivotTable on the data in HC_Clusters, report the characteristics of each cluster.
Below is the Pivot table on the data in KM_Cluster1.
?
a. The interval with the low waiting time is separated into two clusters with respect to Purchase amount, Age, and Customer satisfaction rating.
You might also like to view...
The last security interest to be perfected is the first in priority over any other perfected security interests.
Answer the following statement true (T) or false (F)
Assume that Bubba orders 15 cases of BBQ chips from Mays Potato Chips for his restaurant, Bubba's BBQ. Mays ships 15 cases of regular chips by mistake. If Bubba decides to keep the regular chips, in spite of the nonconformity with the contract, then the destruction of the chips when a water pipe breaks in the food storage room will result in:
a. Mays' having to bear the loss, because it shipped nonconforming goods to Bubba. b. Mays' having to bear the loss, because it failed to insure the chips. c. Bubba's having to bear the loss, because he accepted delivery of the nonconforming chips. d. Bubba's having to bear the loss, because it was a sale on approval contract.
Marsha Bogswell is the sole stockholder of Bogswell Legal Services. Which accounting principle requires Marsha to keep her personal financial information separate from the financial information of Bogswell Legal Services?
A. Monetary unit assumption. B. Expense recognition (Matching) principle. C. Business entity assumption. D. Measurement (Cost) principle. E. Going-concern assumption.
Which alternative is not characteristic of an Internet broker?
A) Easy account access for placing and monitoring orders B) Typically offers an excellent Web site C) Places restrictions on the number of trades you can make D) Has very low commissions