Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

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.

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

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

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

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

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

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

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

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91592191
  • Price:- $120

Guranteed 48 Hours Delivery, In Price:- $120

Have any Question?


Related Questions in DBMS

Question we can sort a given set of n numbers by first

Question : We can sort a given set of n numbers by first building a binary search tree containing these numbers (using TREE-INSERT repeatedly to insert the numbers one by one) and then printing the numbers by an inorder ...

Students will select a situation or problem from their

Students will select a situation or problem from their company as a course project that can be solved using a database system. Using MS Access, or MS SQL Server Express, students will create a relational database model o ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

In sql developercreate a table userpermissions provide

IN SQL DEVELOPER Create a table UserPermissions (provide create and insert statements code) Document UserName Policy SYSTEM Menu JDOW W2 USAM Permissions SYSTEM W2 JDOW Form 1040 USAM Policy JDOW W2 SYSTEM Write a PL/SQL ...

Real time analytics - data analytics assignment -this is a

Real Time Analytics - Data Analytics Assignment - This is a business analytics project aimed at generating innovative analytics solutions for a Global Food Consulting firm working in the area of Animal agriculture and fa ...

Question find at least two academic sources that describe

Question: Find at least two academic sources that describe the movement of Enterprise resource planning (ERP) activities to the cloud. Discuss the types of ERP activities that can be conducted in the cloud and the pros a ...

Question create an erd for the following scenario once you

Question: Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ...

This is a starting out with visual basic programming

This is a starting out with visual basic programming problem, meaning its a basic programming nothing advanced. Question: Add a linq statement to the combo box text-changed event to dispaly the city field of the selected ...

Answer the following question explain the difference

Answer the following Question : Explain the difference between a database management system (DBMS) and a database. Are Microsoft Access, SQL Server, and Oracle examples of databases or database management systems (DBMS)?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As