Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume that you are an analyst working for a local bank. You are tasked with helping the marketing team to understand factors impacting customer decisions

Assume that you are an analyst working for a local bank. You are tasked with helping the marketing team to understand factors impacting customer decisions and directly target individual customers who are more likely to subscribe to the bank's new term-deposit financial product.
The training data is generated as a result of this bank's ongoing direct marketing campaign and includes the results of the campaign this campaign up until now.
You are specifically asked to, first, help the marketing manager to understand what is (are) the most important attribute(s) in determining whether a customer is going to subscribe to the new product; and, second, to help the marketing team identify customers who are most likely to subscribe to the product by providing the team with best performing predictive model.
You are not expected to deploy your model but only to identify the best-performing one.
Data Understanding - Data Dictionary:
age (numeric)
job : type of job (categorical: "admin.", "unknown", "unemployed", "management", "housemaid", "entrepreneur", "student", "blue-collar", "self-employed", "retired", "technician", "services")
marital : marital status (categorical: "married", "divorced", "single"; note: "divorced" means divorced or widowed)
education (categorical: "unknown", "secondary", "primary", "tertiary")
default: has credit in default? (binary: "yes", "no")
balance: average yearly balance, in euros (numeric)
housing: has housing loan? (binary: "yes", "no")
loan: has personal loan? (binary: "yes", "no")
contact: contact communication type (categorical: "unknown", "telephone", "cellular")
pdays: number of days that passed by after the client was last contacted from a previous campaign (numeric,-1 means client was not previously contacted)
previous: number of contacts performed before this campaign and for this client (numeric)
Subscribed - has the client subscribed to a term deposit? (binary: "yes", "no"
Questions and Required Analysis
Considering the data specifications and stated business goal(s), what are possible data modeling methodologies that you can use to achieve stated goals?
Explain your reasoning on why you selected those specific methodologies in question 1.
Do you have to prepare your data in order to be used with any of the previously identified methodologies? If so, explain what needs to be done and prepare your data accordingly.
Of all methodologies that can be used on this problem (your question 1) which one(s) is(are) better suited to provide a good understanding of what attribute(s) affect your target variable the most.
Explain your reasoning on why you selected those specific methodologies in question 4.
Hint: You should focus on capabilities and characteristics of selected methodologies versus those that were not suitable for the stated purpose of question 4.
Relying on your response to the previous questions, build a model to better understand what attribute(s) affect the target variable and answer the following questions
Which modeling technique did you end up choosing for this purpose, and why did you go with that modeling technique (10 pt)
What is(are) the most important attribute(s) affecting the target variable according to the results of your modeling effort. (5 pt)
Which modeling technique gives you the best performance in predicting the desired outcome (5 pts)? How does your chosen modeling technique compares to other candidates? Report your final model performance measure. (10 pts)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And Transact SQL

Authors: Lucy Scott

1st Edition

1974679985, 978-1974679980

More Books

Students also viewed these Databases questions

Question

Define Management by exception

Answered: 1 week ago

Question

Explain the importance of staffing in business organisations

Answered: 1 week ago

Question

What are the types of forms of communication ?

Answered: 1 week ago

Question

Group Size and Communication

Answered: 1 week ago

Question

Understanding Group Roles

Answered: 1 week ago