Develop model that predict customers probability

Assignment Help Database Management System
Reference no: EM131569279

Dataset -

  • Consumer credit usage data that contains credit line granted to a customer, their payment and balance history, demographics and their default status.
  • Data Dictionary (below): Contains definition of all the attributes on .csv file.

Questions -

1. Develop model(s) that predict customers' probability of default and outline the methodology used. It could include (but not limited to) the following:

  • Data cleansing steps
  • Feature engineering and selection
  • Rationale behind choosing the modeling technique(s)
  • Model selection criteria
  • Model diagnostics

2. Summarize key drivers and their relationship with default rate (Y).

3. Perform model validation.

4. Based on your findings what recommendations would you make to the business.

Delivery method - Please submit the following via email:

  • Runnable code,
  • Any spreadsheets or data frames used and
  • List of packages used
  • Create a few slides to describe the process, share the findings.

Data Dictionary -

X1: Amount of the given credit : it includes both the individual consumer credit and his/her family (supplementary) credit.

X2: Gender (1 = male; 2 = female).

X3: Education (1 = graduate school; 2 = university; 3 = high school; 4 = others).

X4: Marital status (1 = married; 2 = single; 3 = others).

X5: Age (year).

X6 - X11: History of past payment. Past monthly payment records (from April to September, 2005) as follows: X6 = the repayment status in September, 2005; X7 = the repayment status in August, 2005; . . .;X11 = the repayment status in April, 2005. The measurement scale for the repayment status is: -1 = pay duly; 1 = payment delay for one month; 2 = payment delay for two months; . . .; 8 = payment delay for eight months; 9 = payment delay for nine months and above.

X12-X17: Amount of bill statement. X12 = amount of bill statement in September, 2005; X13 = amount of bill statement in August, 2005; . . .; X17 = amount of bill statement in April, 2005.

X18-X23: Amount of previous payment. X18 = amount paid in September, 2005; X19 = amount paid in August, 2005; . . .;X23 = amount paid in April, 2005.

Y = default (Yes = 1, No = 0)

Attachment:- Assignment Files.rar

Reference no: EM131569279

Questions Cloud

Explain the pigeon-hole principle : Let S = {2, 3,5,7, 11, 13, 17, 19} be the set of prime numbers less than 20. If A is a subset of S, we can form the sum and product of the elements of A.
How organizational functions such as marketing influence : Evaluate how organizational functions, such as marketing, finance, human resources, and operations, influence and determine the organizational structure?
Devise a chart to organize : Devise a chart to organize your findings according to (a) the stories covered and (b) the way the stories are covered. What patterns emerge?
Investment that will yield a lump sum : How much do you need to invest today to reach the above future value?
Develop model that predict customers probability : Develop model(s) that predict customers' probability of default and outline the methodology used. Perform model validation
Evaluate existing resources and organizational capabilities : Identify the existing performance deficiencies within the organization. Evaluate the existing resources and organizational capabilities.
Opportunity to purchase an investment : An investor has an opportunity to purchase an investment that will provide $11,000 at the end of three years, and $50,000 at the end of five years.
Discuss failed television programs : Analysis. After reviewing your research, identify specific problems that may have contributed to your program's failure to stay on the air. Discuss
Evaluate completeness of honests strategy for future growth : Discussion: Growing Honest Tea- Suppose Honest Tea has hired you as a consultant to evaluate the completeness of their strategy for future growth.

Reviews

len1569279

7/18/2017 8:04:24 AM

Need excellent case analysis as per data attached. Excel analysis + word report. 7 references. The background is mutual fund distribution. Please keep the case 100% confidential. Summarize key drivers and their relationship with default rate. Create a few slides to describe the process, share the findings.

Write a Review

Database Management System Questions & Answers

  Identify the modality of the relationship

You are working on the database design that will support PPI's new order entry system. PPI has many thousands of customers around the world who place and pay for orders. One customer can place an order for many products at a time.

  Create a flowchart and pseudocode using control breaks

The system should store the current inventory levels for different raw materials in a file.

  What % of the survey participants are in each department

Be sure to include other ways that probability is used in business. (Feel free to use the Business Source Premier Database in the Library as a resource to research.)

  What is the purpose of performing a feasibility assessment

How Technology Can Ease Supply Chain Management and Mitigate Risk - What is the purpose of performing a feasibility assessment

  Design a query that will allow the finance department

Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finan..

  Compute the total time to transmit the entire data file

Compute the total time to transmit the entire data file. Compute the effective throughput of the system.

  Describe your experiences related to your setup of mysql

Describe the approach that you would take to go from a conceptual or logical model that you created to the implementation of that database structure in MySQL. Determine the additional information that you will need to implement the database design..

  Identifying risk in an organization and the environment

Identifying risk in an organization and the environment in which it operates is the first step in approaching a potential audit and designing an effective audit program.

  Explain the life cycle of an information systems

Imagine that you run a photography printing store. Your employees have been using punch cards for time entry since you started the business.

  Create the rdm with appropriate attributes

Create the RDM with appropriate attributes, based on the newly added entities created by you. List the business rules and constraints that apply to the business case as outlined.

  Implement a transaction-level consistency

Implement a transaction-level consistency in relational database management system

  Making a simple xml tree out of the given data

Making a simple XML tree out of the given data and using Xpath to navigate through it

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