Use the data file DemoKTC file to conduct the following analysis. Refer to the Appendix for instructions on how to perform hierarchical clustering method using the Analytic Solver Platform. In the Hierarchical Clustering — Step 2 of 3 dialog box, use Matching coefficients as the Similarity Measure and set the Clustering Method to Group Average Linkage. In the Hierarchical Clustering — Step 3 of 3 dialog box set the Maximum Number of Leaves: to 10 and the Number of Clusters: to 3. Click on the datafile logo to reference the data. (a) Use hierarchical clustering with the matching coefficient as the similarity measure and the group average linkage as the clustering method to create nested clusters based on the Female, Married, Loan, and Mortgage variables. Specify the construction of 3 clusters. How would you characterize each cluster? Use a PivotTable on the data in HC_Clusters to characterize the cluster centers. If your answer is zero enter "0". Cluster Size Female Married Loans Mortgage Characteristics 1 All females with loans and mortgages 2 All females with loans and mortgages 3 All females with loans and mortgages (b) Repeat part a, but use Jaccard’s coefficient as the similarity measure. How would you characterize each cluster? If your answer is zero enter "0". Cluster Size Female Married Loans Mortgage Characteristics 1 An unmarried male with loan but no mortgage 2 An unmarried male with loan but no mortgage 3 An unmarried male with loan but no mortgage