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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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