StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Would Taiwanese Customers Default on Their Loan Repayments - Report Example

Cite this document
Summary
This report "Would Taiwanese Customers Default on Their Loan Repayments" presents data analytical results that seek to help in determining whether or not, the Taiwanese customers would repay their loans. The determination of whether they will pay or not depends on the reliability of the data…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER93.5% of users find it useful

Extract of sample "Would Taiwanese Customers Default on Their Loan Repayments"

Report on Whether Taiwanese Customers will Default on their Loan Repayments Name: Year: Table of Contents Introduction 3 1A. Initial Data Exploration 3 Attribute type 3 Nominal 3 Ordinal 4 Interval 4 Ratio 4 2. Summarizing Properties 5 Means 5 Median 5 Range 6 Frequencies/Mode 7 Distributions 7 Measures of spread (Variance and standard deviation) 8 Percentiles and Inter-quartile range 8 1B Preprocessing 9 a. Binning 9 Equi-width binning 9 Equi-depth binning 10 b. Normalization 10 Min-max normalization 10 Z-score normalization 11 c. Discretization 11 d. Education Binarization 12 Summary 14 References 15 Introduction This report presents data analytical results that seek to help in determining whether or not, the Taiwanese customers would repay their loans. The determination of whether they will pay or not depends on the reliability of the data in making such a decision. The reliability measures is based on the distribution characteristics of the attributes of data (Shevlyakov and Vilʹchevskiĭ, 2002). The conclusion on the matter is based on the analytical results of the current records. The analytical results of the given data is as follows. Note: The year of reference in this report is 2005 1A. Initial Data Exploration Attribute type For this dataset, the data attributes are identified as either nominal, ordinal, interval or ratio. The loan information contained in dataset included the customer id, loan limit balance, gender, education, marital status, age, past monthly payment records, bill statement, and defaulting information. Nominal According to Stephens (2009), nominal data/scale can simply be described as a name or better put, label. In this sample data, the nominal data includes the customer Id, marital status (dichotomous), sex (dichotomous) and default status (dichotomous). Ordinal An ordinal data set/scale is one which has hierarchical dimensions. I.e, order matters. In this particular case, the data that order matters include education, repayment delay status (Stephens , 2009). Interval Interval scales can be described as the numeric scales in which not only the order, but also the exact differences between the values. The given classic example would be temperature. There is no such thing as ‘no temperature’ and 40 and 50 degrees celcius is the difference between 90 and 100 degrees Celcius is the same 10 degrees. Interval scales can give an easier realm of statistical analysis on the data sets. In this particular case, data attribute with such characteristics is the age, limit balance, monthly amount paid, monthly bill statement. Ratio Stephens (2009) describes ratio scales as data which can have an absolute zero-which allows for a wide range of descriptive and inferential statistics. Ratio scales are those which can be easily have their ratios computed (subtraction, multiplication, addition) and have measures of central tendency easily determined eg the mean, median and measures of dispersion such as the standard deviation, coefficient of variation. In this data set, the first data set that meets this description is the age, limit balance, monthly bills and the monthly payment amount. Simply put, in this particular case, all the interval data attributes up there are ratio data attributes as well. In fact, when it comes to the monthly computations, they are mainly ratio data. 2. Summarizing Properties Means Except for the case of high influence of the outliers, the mean is used to give a generalized representation of the data (Bowman and Robinson, 2007). In this case, the mean would be used to represent the average amount given to the customers, the average age of the customers, the average payments for each month (so as to compare the month statistics) and the average monthly repayments. For this dataset, the mean amount given out to the customers is 167065 NT Dollar, with an average borrowing age of 35-36 (35.7 years average) years. The average bill amounts for the months from September backwards to April are approximately: 51628, 49326, 47153, 44021, 41599, And 40130 NT Dollars respectively. From this it can be seen that towards September from April, the average Bill amounts were increasing with highest average in September. The average amounts paid by the customers for the months of September backwards to April are approximately 5732, 6248, 5964, 5054, 4553 and 5623 NT Dollars respectively. On average, the month of August recorded the highest amount of repayment by the customers. Median The median is much more like the middle of the data set about which values lie above and below and may give a more robust representation of the customer behavior compared to the mean computed above. It can also be said to be a more representative of the population than the mean (Bowman and Robinson, 2007). The median amount given out to customers is 140000 NT Dollars The median age of customers is 34 years. The median bills for September backwards to April are 20633, 20072, 19155, 18808, 17875 and 16477 NT Dollars respectively. September records the highest representative bills of the months given. The median monthly repayments from September backwards to April are 2101 2055 1842 1526.5 1500 1500 NT Dollars respectively. The median shows September as the month with the highest repayments and with the repayments increasing from April to September. In this case, The median may be viewed as more representative of the customers as opposed to the mean which is highly affected by the outliers (Bowman and Robinson, 2007). The median for defaulting status is 0 indicating no defaulting. Range The range is used to determine the difference between the smallest and the highest recording of the data. The difference between the highest and the smallest amount borrowed is 990000 NT Dollars. The difference between the youngest and the oldest borrowers is 52 years. The range for the Bills from September backwards to April is 979819, 1017281, 553215, 907174, 988543, 986584, NT Dollars respectively. August has the highest difference between the smallest and the largest Bill and July has the smallest difference. The repayment range is 260416 358689 896040 281225 207019 528666 NT Dollars for September to backwards to April respectively. July has the smallest difference between the highest and lowest repayment. Frequencies/Mode This measure is used to determine the mostly occurring entry.. It is very helpful in determining which group of a given attribute has the highest score/occurrence. In this case, 50000 NT Dollars is the amount that was most given out to the customers. There were more females borrowing compared to males. Most of the customers are University students. In terms of marriage, most of the customers are single. The largest borrowing age is 27 years. The payment status show that people mostly repaid earlier than due date for all the months. Both bills and the repayment amounts do not show one particular entry that mostly occurred. Defaulting for next month shows that most of the customers did not default payment for the next month the default status of highest frequency is 0 meaning more of the customers did not default on payment. Distributions With respect to this case, the most appropriate data attribute distribution analysis is the age. In this particular case, the age distribution analysis was as shown below ranges Age bands Age Distribution 59 26 Equi-depth binning Equi-depth binning is also known as equal-frequency binning. It is carried by classifying the data into classes of equal frequency. According to Han et al (2012), equi-depth binning divides data into N groups with each group having approximately same number of values. Using excel, the desired frequency for the age was determined to be 10 and then the equi-depth binning carried out using the function below. b. Normalization Min-max normalization The min-max normalization involves dividing the difference between a particular value and the minimum value of the dataset by the range of the dataset. A min-max score is an index of how much the value is far from the minimum value of the dataset. The min-max normalization may not give a true smoothing of the given data since the maximum value and the minimum values may be outliers (Brackett, 2012). A plot of the min-max is as shown below Figure1: The min-max distribution. The score is always positive Z-score normalization The Z-score was carried out by dividing the difference between the value and the mean by the standard deviation. The Z-normaization can be a better smoothing criterion compared to min-max normalization (Brackett, 2012). The Z-score helps us determine the probability of a score occurring within within our normal distribution. The scores closer to the mean have the highest probability of occuring. Below is a plot of the Z-normalization. c. Discretization In order to carry out data discretization, Excel If function was applied to filter and assign the discretization values that describe the age bracket into which a particular age falls. To carry out the process, age was determined to be of the groups in the teenage, young, mid-age, mature and old age ranges 66 respectively. This classification was in accordance with Grasso and Burkins’ (2010) categorisation criterion. The excel if function entered was as shown below A2=IF(A2=66,"Old",IF(A2 Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Would Taiwanese Customers Default on Their Loan Repayments Report, n.d.)
Would Taiwanese Customers Default on Their Loan Repayments Report. https://studentshare.org/statistics/2066891-data-exploration-and-preparation
(Would Taiwanese Customers Default on Their Loan Repayments Report)
Would Taiwanese Customers Default on Their Loan Repayments Report. https://studentshare.org/statistics/2066891-data-exploration-and-preparation.
“Would Taiwanese Customers Default on Their Loan Repayments Report”. https://studentshare.org/statistics/2066891-data-exploration-and-preparation.
  • Cited: 0 times

CHECK THESE SAMPLES OF Would Taiwanese Customers Default on Their Loan Repayments

The UK Social Fund

Payment of Budgeting and Crisis Loans can also be refused on the grounds that you are unable to pay the loan back".... For example, one-third of families on Income Support receive a Budgeting or Crisis loan each year, the only interest-free formal loan available....
7 Pages (1750 words) Coursework

The Risks, Costs, and Benefits of Consumer Loan Options and Steps Needed To Control Costs

The research paper "The Risks, Costs, and Benefits of Consumer loan Options and Steps Needed To Control Costs" presents how important for banks to have an effective credit management system, policy on loan facilities, ability to measure levels of risks and a clear loan review procedures.... … From this research it is clear that consumer loan is the amount of money that a bank lends to an individual.... Before banks issues loan facility to customers, there should be a clear calculation on the amount of money to be recovered on installments basis, as well as, the amount of interest payable....
3 Pages (750 words) Research Paper

Credit Scoring

If the capital invested is way below the amount borrowed, then that could raise red flags in his ability to repay the loan.... Capacity- The borrower is gauged on his sufficiency of yielding positive cash flows during the loan repayment period and the amount is pre-calculated using different analysis criteria such as the Net Present Value, Profitability Index.... If he passes this stage, he has to provide a credible plan on his willingness to repay his loan when it's due....
7 Pages (1750 words) Assignment

Export-Import Bank

product may seek for a loan from a commercial bank.... To cover itself from the inherent credit risk, the… The loan guarantee would be issued to cover the debt obligations in case the foreign buyer defaults.... Such medium and long-term loan guarantees have continuously loan guarantees al Affiliation) Introduction The Export-Import bank (Ex-Im) has offered various forms of support to address the credit risk associated with a foreign buyer of a U....
2 Pages (500 words) Case Study

The Nature of the Collateralized Loan Obligation and How it Works

The focus of this paper is on the collateralized loan obligation, a form of low-interest loan that comprises of a pool of debt backed up by some form of security.... While it is clear that the CLO was among the factors that led to the financial crisis that hit the world, it is clear that it is still a favorable form of loan for many investors.... In 2014, it is evident that investors have ventured into the form of loan due to its higher returns as compared to other forms of loans....
8 Pages (2000 words) Essay

AMEX's Performance - Strategy of the Company That Safely Transports Customers Assets

The paper “AMEX's Performance - Strategy of the Company That Safely Transports customers Assets” presents company's marketing strategy, SWOT and situation analysis, organizational objectives, description of the marketing mix, segmentation, positioning, and targeting strategy, etc.... hellip; American Express world's largest issuer of charge and credit card, caters to the affluent segment and possesses expertise in evaluating the credit risk of individual customers....
11 Pages (2750 words) Research Paper

Strategic Default

In fact, defaulting on the mortgage payments seems to be the only option for the homeowners if he were to make his decision to default on a purelyly financial basis.... This essay "Strategic default" outlines the legal and ethical constraints associated with such defaults and then discusses its implications on the lender, the borrower and the society as a whole.... If judging the option of strategic default purely on moral or ethical grounds then it is surely wrong to knowingly gobble up other people's owed amount and hence should be avoided at all costs....
7 Pages (1750 words) Essay

Analysis of Central Bank Digital Currencies Loan

The youth loan can be up to $ 20,000 per eligible borrower loan has competitive interests' rates and repayments terms and can be utilized for the purchase of startup, fixed assets and the working capital.... The loan is a repayable loan with competitive repayments terms and rates.... … The paper "Summary And Analysis Of CBDC loan" is an excellent example of a business essay.... The paper "Summary And Analysis Of CBDC loan" is an excellent example of a business essay....
1 Pages (250 words) Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us