ITC516 - Data Mining and Visualisation for Business Intelligence Assessment item 2

Business Case Analysis 11. Dimension Reduction (5%)

This item requires the dataset Utilities.xls which can be found on the subject Interact site. This dataset gives corporate data on 22 US public utilities. We are interested in forming groups of similar utilities. The objects to be clustered are the utilities.

There are 8 measurements on each utility described below. An example where clustering would be useful is a study to predict the cost impact of deregulation. To do the requisite analysis economists would need to build a detailed cost model of the various utilities.

It would save a considerable amount of time and effort if we could cluster similar types of utilities and to build detailed cost models for just one ”typical” utility in each cluster and then scaling up from these models to estimate results for all utilities. The objects to be clustered are the utilities and there are 8 measurements on each utility.

X1: Fixed-charge covering ratio (income/debt)

X2: Rate of return on capitalX3: Cost per KW capacity in placeX4: Annual Load FactorX5: Peak KWH demand growth from 1974 to 1975X6: Sales (KWH use per year)X7: Percent NuclearX8: Total fuel costs (cents per KWH)

a. Conduct Principal Component Analysis (PCA) on the data. Evaluate and comment on the Results. Should the data be normalized? Discuss what characterizes the components you consider key and justify your answer.

b. Briefly explain advantages and any disadvantages of using the PCA compared to other methods for this task.

2. Naïve Bayes Classifier (10%)

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 etc.), 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) 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

Business Case Analysis 11. Dimension Reduction (5%)

This item requires the dataset Utilities.xls which can be found on the subject Interact site. This dataset gives corporate data on 22 US public utilities. We are interested in forming groups of similar utilities. The objects to be clustered are the utilities.

There are 8 measurements on each utility described below. An example where clustering would be useful is a study to predict the cost impact of deregulation. To do the requisite analysis economists would need to build a detailed cost model of the various utilities.

It would save a considerable amount of time and effort if we could cluster similar types of utilities and to build detailed cost models for just one ”typical” utility in each cluster and then scaling up from these models to estimate results for all utilities. The objects to be clustered are the utilities and there are 8 measurements on each utility.

X1: Fixed-charge covering ratio (income/debt)

X2: Rate of return on capitalX3: Cost per KW capacity in placeX4: Annual Load FactorX5: Peak KWH demand growth from 1974 to 1975X6: Sales (KWH use per year)X7: Percent NuclearX8: Total fuel costs (cents per KWH)

a. Conduct Principal Component Analysis (PCA) on the data. Evaluate and comment on the Results. Should the data be normalized? Discuss what characterizes the components you consider key and justify your answer.

b. Briefly explain advantages and any disadvantages of using the PCA compared to other methods for this task.

2. Naïve Bayes Classifier (10%)

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 etc.), 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) 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

Oct 05, 2019

SOLUTION.PDF## Get Answer To This Question

- Bootcamp: UTOR-VIRT-DATA-PT XXXXXXXXXXU-B-TTHAssignmentsModule 19 ChallengeOct-2021HomeNavigatorModulesSyllabusGradesZoomAttendanceCareer ServicesCareer EventsStudent SupportBillingCareer EventsModule...SolvedMar 19, 2022
- 3/9/22, 11:46 PM Module 18 Challengehttps://courses.bootcampspot.com/courses/967/assignments/19043?module_item_id= XXXXXXXXXX/19Module 18 ChallengeDue Sunday by 23:59 Points 100 Submitting a...SolvedMar 10, 2022
- BackgroundSince your work with Jennifer on the SellBy project was so successful, you’ve been tasked with another, larger project: analyzing Amazon reviews written by members of the paid Amazon Vine...SolvedMar 02, 2022
- 3/2/22, 10:28 AM Module 17 Challengehttps://courses.bootcampspot.com/courses/967/assignments/19041?module_item_id= XXXXXXXXXX/14Module 17 ChallengeDue 6 Mar by 23:59 Points 100 Submitting a...SolvedMar 02, 2022
- HR Metrics: aSSIGNment 2 (15%)PROJECT SUMMARYThis is an individual project.You are to create these reports based on the dataset within the Assignment 2 folder:1. a corporate profile...SolvedFeb 10, 2022
- BackgroundBasil and Sadhana like how you created your earthquake map with two different maps and the earthquake overlay. Now, Basil and Sadhana would like to see the earthquake data in relation to the...SolvedFeb 02, 2022
- 1/25/22, 12:41 PM Module 12 Challengehttps://courses.bootcampspot.com/courses/967/assignments/19027?module_item_id= XXXXXXXXXX/19Module 12 ChallengeDue 30 Jan by 23:59 Points 100 Submitting a...SolvedJan 25, 2022
- Consider the following similar problems to be solved in MapReduce paradigm. We have two text files as follows: File1: Every vaccinated person has good protection against the virus. A vaccinated person...SolvedJan 25, 2022
- A1: Text Adventure Game DevelopmentDue Thursday by 10pm Points 100 Submitting a file upload File Types ipynbAvailable until Jan 27 at 10pmStart AssignmentText Adventure Game...SolvedJan 24, 2022
- 1/18/22, 11:15 AM Module 11 Challengehttps://courses.bootcampspot.com/courses/967/assignments/19023?module_item_id= XXXXXXXXXX/11Module 11 ChallengeDue 23 Jan by 23:59 Points 100 Submitting a...SolvedJan 18, 2022

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.