Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ITC516 Data Mining And Visualisation For Business Intelligence

tag 0 Download 1 Pages / 178 Words tag 30-07-2021

Question:

This item requires the dataset UniversalBank.xls which can be found on the subject Interact site.The following is a business analytical problem faced by financial institutions and banks. The objective is to determine the measurements for personal loan acceptance.The dataset UniversalBank.xls contains data on 5000 customers of Universal Bank. The data include customer demographic information (age, income, etc.), the customer’s relationship with the bank (mortgage, securities account  and the customer response to the last personal loan campaign (Personal Loan). Among these 5000 customers,only 480 (= 9.6%) accepted the personal loan that was offered to them in the earlier campaign. In this exercise we focus on two predictors.
 
Online (whether or not the customer is an active user of online banking services) and Credit Card (abbreviated CC below) (does the customer hold a credit card issued by the bank), and the outcome Personal Loan (abbreviated Loan below). Partition the data into training (60%) and validation (40%) sets. a. Create a pivot table for the training data with Online as a column variable, CC as a row variable, and Loan as a secondary row variable. The values inside the cells should convey the count (how many records are in that cell).
b. Consider the task of classifying a customer who owns a bank credit card and is actively using online banking services. Analyse the pivot table and calculate the probability that this customer will accept the loan offer. Note: This is the probability of loan acceptance (Loan=1) conditional on having a bank credit card (CC=1) and being an active user of online banking services (Online=1).
c. Design two separate pivot tables for the training data. One will have Loan (rows) as a function of Online (columns)
and the other will have Loan (rows) as a function of CC. Compute the following quantities [P(A | B) means “the probability of A given B”]:

i. P(CC=1 | Loan=1) (the proportion of credit card holders among the loan acceptors) 9/6/2017 interact.csu.edu.au/sakai-msi-tool/content/bbv.html?subjectView=true&siteId=ITC516_201760_SM_I
http://interact.csu.edu.au/sakai-msi-tool/content/bbv.html?subjectView=true&siteId=ITC516_201760_SM_I 2/2
ii. P(Online=1 | Loan=1)
iii. P(Loan=1) (the proportion of loan acceptors)
iv. P(CC=1 | Loan=0)
v. P(Online=1 | Loan=0)
vi. P(Loan=0)
d. Using the quantities computed in (c), compute the Naive Bayes probability P(Loan=1 | CC=1, Online=1).
e. Based on the calculations above, suggest the best possible strategy for the customer to get the loan. 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 1 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). ITC516 Data Mining And Visualisation For Business Intelligence. Retrieved from https://myassignmenthelp.com/free-samples/itc516-data-mining-and-visualisation-for-business-intelligence/analytical-problem.html.

"ITC516 Data Mining And Visualisation For Business Intelligence." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/itc516-data-mining-and-visualisation-for-business-intelligence/analytical-problem.html.

My Assignment Help (2021) ITC516 Data Mining And Visualisation For Business Intelligence [Online]. Available from: https://myassignmenthelp.com/free-samples/itc516-data-mining-and-visualisation-for-business-intelligence/analytical-problem.html
[Accessed 27 January 2023].

My Assignment Help. 'ITC516 Data Mining And Visualisation For Business Intelligence' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/itc516-data-mining-and-visualisation-for-business-intelligence/analytical-problem.html> accessed 27 January 2023.

My Assignment Help. ITC516 Data Mining And Visualisation For Business Intelligence [Internet]. My Assignment Help. 2021 [cited 27 January 2023]. Available from: https://myassignmenthelp.com/free-samples/itc516-data-mining-and-visualisation-for-business-intelligence/analytical-problem.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.