Explore ways of converting depositors to borrowers

Assignment Help Database Management System
Reference no: EM13919290

Universal Bank is a young bank growing rapidly in overall customer acquisition. The majority of these customers are depositors with varying sizes of relationship with the bank. The customer base of borrowers is quite small, and the bank is interested in expanding this base to bring in more loan business. In particular, it wants to explore ways of converting depositors to borrowers while retaining them as depositors.

A campaign that the bank ran last year for depositors showed a healthy conversion rate of over 9% success. This has encouraged the retail marketing department to devise smarter campaigns with better targeted marketing. The goal of this assignment is to model the previous campaign's customer behavior to analyze what combination of factors make a customer more likely to accept a personal loan. This will serve as the basis for the design of a new campaign.

The file UniversalBank contains data on 5000 customers. The data include customer demographic information, account information, and the customer response to the last personal loan campaign. The layout of the file is described below. The last five columns are Yes/No responses. 0 = No; 1 = Yes.

Data Description:

ID

Customer ID

Age

Customer's age in completed years

Experience

#years of professional experience

Income

Annual income of the customer ($000)

Family

Family size of the ustomer

CCAvg

Avg. spending on credit cards per month ($000)

Mortgage

Value of house mortgage if any. ($000)

Securities Account

Does the customer have a securities account with the bank?

CD Account

Does the customer have a certificate of deposit (CD) account with the bank?

Online

Does the customer use internet banking facilities?

CreditCard

Does the customer use a credit card issued by UniversalBank?

Personal Loan

Did this customer accept the personal loan offered in the last campaign?


In this assignment, you will use a set of R scripts that I wrote to train and test a K nearest neighbors (KNN) classifier for the UniversalBank data set.

The script UB_tr_vl_ts.R partitions UniversalBank into a training set (50% of the cases), a validation set (30% of the cases) and a test set (20% of the cases). This process corresponds to slides 6 and 7 in this week's slide deck.

With the script BillsKNNtrain.R, you supply k, the number of neighbors to use in the analysis, and R calculates the training error and the validation set results including the confusion matrix, the error rate, the true positive rate and the true negative rate.

With the script BillsKNNtest.R, you supply k, the number of neighbors to use in the analysis, and R calculates the test set results including the confusion matrix, the error rate, the true positive rate and the true negative rate.

To complete this assignment, answer the questions below in a Word document and submit the document by the due date.

1) Produce a table similar to the one shown in this week's slide 15. Investigate k values from 1 through 20 and report the training error and the validation error.

2) From your results in question 1, choose the best value of k for this analysis and explain your choice..

3) Run BillsKNNtest.R for your chosen value of k.

4) From your results in questions 1, 2 and 3, what error rate can you expect on new data if you use your chosen value of k? Explain how you arrived at your answer.

5) For your chosen value of k, explain why the Validation Confusion Percentages and the Test Confusion Percentages are different.

6) Explain how we avoid overfitting in the development of this knn classifier.

7) Explain why the training error for a 1 nearest neighbor classifier is always 0.

8) What do the True Positive Rate and the True Negative Rate tell us about the performance of the classifier? Why might this information be useful to someone using the classifier?

9) Evaluate the following statement. Since every student uses the same UniversalBank.txt file, every student's confusion matrices should be exactly the same.

https://wikisend.com/download/761982/BillsKNNtrain.R

[URL=https://wikisend.com/download/761982/BillsKNNtrain.R]BillsKNNtrain.R[/URL]

https://wikisend.com/download/616584/UB_tr_vl_ts.R

[URL=https://wikisend.com/download/616584/UB_tr_vl_ts.R]UB_tr_vl_ts.R[/URL]
https://wikisend.com/download/139866/UniversalBank.txt.docx

[URL=https://wikisend.com/download/139866/UniversalBank.txt.docx]UniversalBank.txt.docx[/URL]

https://wikisend.com/download/640962/BillsKNNtest.R

[URL=https://wikisend.com/download/640962/BillsKNNtest.R]BillsKNNtest.R[/URL]

Reference no: EM13919290

Questions Cloud

Manual of the kubiszyn and borich textbook : Mr. Smith, a ninth grade teacher, has had a personal animosity towards grades ever since he unjustly received a "C" in one of his college courses. After this experience, he swore he would always be a fair grader and has therefore devised an extens..
What is the annual yield you anticipate for the investment : Recommend how much of the $800,000 should be invested in each of the three funds. What is the annual yield you anticipate for the investment recommendation?
What are two key components of service quality : What are two key components of service quality. Why are these components particularly important to service system quality (when compared to manufacturing system quality).
Perform an analysis of reep constructions leasing problem : Perform an analysis of Reep Construction's leasing problem and prepare a report for Bob Reep that summarizes your findings. Be sure to include information on and analysis of the following items: The optimal leasing plan.
Explore ways of converting depositors to borrowers : Universal Bank is a young bank growing rapidly in overall customer acquisition. The majority of these customers are depositors with varying sizes of relationship with the bank. The customer base of borrowers is quite small, and the bank is interes..
Make annual withdraws : What deposit must be made each month until the man retires so that he can make annual withdraws of $60,000 in terms of today's dollars over the next 15 years following his retirement
Product costs reflect the actual direct material costs : When product costs reflect the actual direct material costs, actual direct labor costs, and actual overhead costs, the cost system being used is a(n): a. direct cost system b. normal costing system c. actual cost system d. common cost system
Correct journal entry to record the transfer : The correct journal entry to record the transfer of $120,000 of raw materials into production is: a. Direct Materials Expense 120,000 Work-In-Process Inventory 120,000 b. Work-In-Process Inventory 120,000 Accounts Payable 120,000
How will you spend your limited funds : Develop a house of quality that helps guide your design of the location (both interior and exterior), operating times, etc. to best fulfill your customers' wishes and help your business be competitive in the marketplace. Try to examine at least 6 ..

Reviews

Write a Review

 

Database Management System Questions & Answers

  Show what makes database connectivity so complex

Show what makes database connectivity so complex and what could be done to simplify it - Add in your discussion why it is utilized despite its complexity.

  What is a relational database

What is a relational database-Write a 1500 word essay on the above question. Your response should include the evolution of 1st generation data models

  Create a clustered index on the groupid column

Write the CREATE INDEX statements to create a clustered index on the GroupID column and a nonclustered index on the IndividuallD column of the GroupMembership table.

  Explain the benefits of normalization

Explain one characteristic of a database that has data redundancy and Briefly explain the benefits of normalization and why we should implement it when designing databases

  Explain normal form is denormalized table

Which field or fields cause a table to no longer be in third normal form? In which normal form is denormalized table?

  Given the file structure shown in figure p11 answer

given the file structure shown in figure p1.1 answer problems 1-4.1.how many records does the file contain? how many

  Assignment 5 logical design part ii problem your e-r model

assignment 5 logical design part ii problem your e-r model from a prior week was a success assignment 2 - logical

  Explain turing and von neumann models

Write a 2 page research paper (excluding the title page) on the Turing and von Neumann models. Compare and contrast each and discuss which model is better and why.

  How many records are returned using minus operator

Customers Dunne an Olowski are included in the CUSTOMER table also in CUSTOMER_2 table. Explain How many records are returned when using the MINUS operator?

  Convert excel files into an access database

The Morris Arboretum tracks donors to their organization in Microsoft Excel. Access for future Arboretum records. In the following project, you convert Excel files into an Access database for Morris Arboretum

  Build a gantt chart using microsoft project

Discuss what it will take to build a Web architecture, move an existing Website with minimal downtime, and provide a disaster recovery solution to ensure the site is always available.

  Web forms and database interaction assignment description

Web Forms and Database Interaction Assignment description, public static bool SavePersonnel(string Database, string FirstName, string LastName, string PayRate, string StartDate, string EndDate)

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd