Question: table [ [ COUNTA of Attrition _ Flag,Attrition _ Flag, ] , [ Income _ Category, table [ [ Attrited ] , [

\table[[COUNTA of Attrition_Flag,Attrition_Flag,],[Income_Category,\table[[Attrited],[Customer]],\table[[Existing],[Customer]]],[$120K+,126,601],[$40K-$60K,271,1519],[$60K-$80K,189,1213],[$80K-$120K,242,1293],[Less than $40K,612,2949],[Unknown,187,925]]
The CRM manager wanted to profile the customers who are staying in the bank based on their income category. She found out the following:
a. Customers who have income between $40K and $80K are the most loyal customers
b. Customers who have income less than $40K are the most loyal customers
c. Customers who have Unknown income are the least loyal customers
d. Customers who have income $120K and more are the most loyal customers
 \table[[COUNTA of Attrition_Flag,Attrition_Flag,],[Income_Category,\table[[Attrited],[Customer]],\table[[Existing],[Customer]]],[$120K+,126,601],[$40K-$60K,271,1519],[$60K-$80K,189,1213],[$80K-$120K,242,1293],[Less than $40K,612,2949],[Unknown,187,925]] The CRM manager wanted to profile

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!