Question

In: Statistics and Probability

Know Thy Customer (KTC) is a financial consulting company that provides personalized financial advice to its...

Know Thy Customer (KTC) is a financial consulting company that provides personalized financial advice to its clients. As a basis for developing this tailored advising, KTC would like to segment its customers into several representative groups based on key characteristics. Peyton Avery, the director of KTC’s fledging analytics division, plans to establish the set of representative customer profiles based on 600 customer records in the file KnowThyCustomer. Each customer record contains data on age, gender, annual income, marital status, number of children, whether the customer has a car loan, and whether the customer has a home mortgage. KTC’s market research staff has determined that these seven characteristics should form the basis of the customer clustering. Peyton has invited a summer intern, Danny Riles, into her office so they can discuss how to proceed. As they review the data on the computer screen, Peyton’s brow furrows as she realizes that this task may not be trivial. The data contains both categorical variables (Female, Married, Car, Mortgage), and interval variables (Age, Income, and Children). Managerial Report Playing the role of Peyton, you must write a report documenting the construction of the representative customer profiles. Because Peyton would like to use this report as a training reference for interns such as Danny, your report should experiment with several approaches and explain the strengths and weaknesses of each. In particular, your report should include the following analyses: 1. Using k-means clustering on all seven variables, experiment with different values of k. Recommend a value of k and describe these k clusters according to their “average” characteristics. Why might k-means clustering not be a good method to use for these seven variables? 2. Using hierarchical clustering all seven variables, experiment with using complete linkage and group average linkage as the clustering method. Recommend a set of customer profiles (clusters). Describe these clusters according to their “average” characteristics. Why might hierarchical clustering not be a good method to use for these seven variables? 3.Apply a two-step clustering method:

    a. Apply hierarchical clustering on the binary variables Female, Married, Car, and Mortgage to recommend a set of clusters. Use matching coefficients as the similarity measure and group average linkage as the clustering method. b. Based on the clusters from part(a), split 600 observations into m separate data sets, where m is the number of clusters recommended from part(a). For each of these m data sets, apply 2-means clustering using Age, Income, and Children as variables. This will generate a total of 2m clusters. Describe these 2m clusters according to their “average” characteristics. What benefit does this two-step clustering approach have over the approaches in the parts (1) and (2)? What weakness does it have?

Solutions

Expert Solution

Solution:

1.1 In K implies bunching the tradition is to utilize the Euclidean separation between highlight vectors. In any case, here as the element vector are comprises of both the subjective and quantitative variable so utilizing Euclidean separation won't work here. Or maybe this is inane. Rather than that one can utilize Bray Curtis divergence measure to compute the separation between the element vectors as they consider both the subjective, for example, sexual orientation and the quantitative factors, for example, Annual pay in the thought.

1.2 The following thing is to pick the quantity of groups. At first, any no of groups can be picked, the default can be picked as though there are n information focuses accessible, at that point we can begin with n/30 no of class centroids. There is no thumb administer or strategy to pick correct no of class centroids, yet what we can do we can part the information 70-30 proportion. prepare the K implies grouping on the 70% of the information. At that point utilize whatever is left of 30% to allocate them to the diverse group, in the wake of appointing this 30% of the point if the first class centroids change definitely then we have to change the no of bunches, there might be a plausibility that more number of bunches are required.

1.3. The principle disservice is that we don't know in earlier what number of groups could be shaped ideally. and furthermore that I have shown before the separation measure ought to have been changed in the wake of seeing the idea of the information.

2. For progressive bunching bunch normal linkage is an extremely unrefined strategy to utilize. It isn't exceptionally useful. Then again, on the off chance that we utilize finish linkage then it uncovers the most extreme separation between two groups .

2.1 It might be helpful to utilize the various leveled bunching on the grounds that at all the stages we can see the full picture and as indicated by our need we can stop at any of the phases with the quantity of group.

There might be loud information and a portion of the highlights may superfluously add clamor to the information. So it probably won't regard utilize progressive bunching .


Related Solutions

Know Thy Customer (KTC) is a financial consulting company that provides personalized financial advice to its...
Know Thy Customer (KTC) is a financial consulting company that provides personalized financial advice to its clients. As a basis for developing this tailored advising, KTC would like to segment its customers into several representative groups based on key characteristics. Peyton Avery, the director of KTC’s fledging analytics division, plans to establish the set of representative customer profiles based on 600 customer records in the file KnowThyCustomer. Each customer record contains data on age, gender, annual income, marital status, number...
Know Thy Customer (KTC) is a financial consulting company that provides personalized financial advice to its...
Know Thy Customer (KTC) is a financial consulting company that provides personalized financial advice to its clients. As a basis for developing this tailored advising, KTC would like to segment its customers into several representative groups based on key characteristics. Peyton Avery, the director of KTC’s fledging analytics division, plans to establish the set of representative customer profiles based on 600 customer records in the file KnowThyCustomer. Each customer record contains data on age, gender, annual income, marital status, number...
Financial Statements and Closing Entries Last Chance Company offers legal consulting advice to prison inmates. Last...
Financial Statements and Closing Entries Last Chance Company offers legal consulting advice to prison inmates. Last Chance prepared the end-of-period spreadsheet that follows at June 30, 20Y3, the end of the fiscal year. Last Chance Company End-of-Period Spreadsheet For the Year Ended June 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 5,100 5,100 Accounts Receivable 22,750 3,750 26,500 Prepaid Insurance 3,600 1,300 2,300 Supplies 2,025 1,500 525 Land 80,000 80,000...
39) Sunland Company provides financial consulting and has collected the following data for the next year’s...
39) Sunland Company provides financial consulting and has collected the following data for the next year’s budgeted activity for a lead consultant. Consultants’ wages $90000       Fringe benefits $22500       Related overhead $17500 Supply clerk’s wages $19000       Fringe benefits $4000       Related overhead $22000 Profit margin per hour $20 Profit margin on materials 15% Total estimated consulting hours 5000 Total estimated material costs $180000 A consulting job takes 20 hours of consulting time and $180 of materials. The client’s...
Sheridan Company provides financial consulting and has collected the following data for the next year’s budgeted...
Sheridan Company provides financial consulting and has collected the following data for the next year’s budgeted activity for a lead consultant. Consultants’ wages $80000       Fringe benefits $32500       Related overhead $27500 Supply clerk’s wages $19000       Fringe benefits $5000       Related overhead $22000 Profit margin per hour $20 Profit margin on materials 15% Total estimated consulting hours 5000 Total estimated material costs $166000 The labor rate per hour is $46.50. $48.00. $28.00. $47.50.
Powerjob Inc. provides employment consulting services. The company adjusts its accounts monthly but performs closing entries...
Powerjob Inc. provides employment consulting services. The company adjusts its accounts monthly but performs closing entries annually on December 31. The firms’s unadjusted trial balance dated December 31, 2019 is shown below. Other data: 1.       Accrued but unrecorded and uncollected consulting fees earned at December 31 total : $25000. 2.       The company determined that $15000 of previously unearned consulting fees had been earned at December 31. 3.       Office supplies on hand at December 31 total $300 4.       The company purchased all of its equipment...
Tripoli Consulting provides financial and estate planning services on a retainer basis for the executive officers...
Tripoli Consulting provides financial and estate planning services on a retainer basis for the executive officers of its corporate clients. It incurred the following labor costs on services for three corporate clients during March 2018: Direct Labor Contact 1 $9,000 Contract 2 $3,600 Contract 3 $14,400 TOTAL $27,000 Tripoli allocated March overhead costs of $13,500 to the contracts based on the amount of direct labor costs incurred on each contract. a. Assuming the revenue from Contract 3 was $40,000, what...
question Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the...
question Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the end-of-period spreadsheet that follows at June 30, 2019, the end of the The annual accounting period adopted by a business.fiscal year: Last Chance Company End-of-Period Spreadsheet For the Year Ended June 30, 2019 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 5,100 5,100 Accounts Receivable 22,750 (a) 3,750 26,500 Prepaid Insurance 3,600 (b) 1,300 2,300 Supplies...
We are a consulting company. Our customer is the BEST COMPUTER STORE which is targeted to...
We are a consulting company. Our customer is the BEST COMPUTER STORE which is targeted to begin operation next year. The store will need an information system to help store customer/sales & inventory information. Our system will be able to add/edit customers/sales & inventory and creates necessary output transactions such as packing slip & invoice. We did Statement of Work, Team & Clear Objectives & Scope, Timeline (PERT and Gantt charts), Assumption and Budget following requirements. Project Name: Project Manager:...
Concord Corporation provides financial consulting and has collected the following data for the next year’s budgeted...
Concord Corporation provides financial consulting and has collected the following data for the next year’s budgeted activity for a lead consultant. Consultants’ wages $85000       Fringe benefits $22500       Related overhead $17500 Supply clerk’s wages $17000       Fringe benefits $3000       Related overhead $21000 Profit margin per hour $20 Profit margin on materials 15% Total estimated consulting hours 5000 Total estimated material costs $164000 A consulting job takes 20 hours of consulting time and $180 of materials. The client’s bill...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT