Data Set Summary:

This data set is from the U.S. Small Business Administration (SBA) and provides historical data from 1987 through 2014. This large data set contains 27 variables and 899,164 observations. Each observation represents a loan that was guaranteed to some degree by the SBA. Included is a variable [MIS_Status] which indicates if the loan was paid in full or defaulted/charged off.

Variables: LoanNr_ChkDgt - Text Name - Text City - Text State - Text Zip - Text Bank - Text BankState - Text NAICS - Text ApprovalDate - Date/Time ApprovalFY - Text Term - Number NoEmp - Number NewExist - Text CreateJob - Number RetainedJob - Number FranchiseCode - Text UrbanRural - Text RevLineCr - Text LowDoc - Text ChgOffDate - Date/Time DisbursementDate - Date/Time DisbrusementGross - Currency BalanceGross - Currency MIS_Status - Text ChgOffPrinGr - Currency GrAppv - Currency SBA_Appv - Currency

Reading Data Set:

The data set BankLoan was read in through github by appending the nine data sets into one inside of r, giving one data set with 899,164 observations.

## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

Removing and Changing Values:

Data cleaning was done here with all records who’s MIS_Status value was missing being deleted. Additionally, all currency values were changed into numerical values.

Combining Categories:

Using the categorical variable “State”, its 51 unique values were changed into 5 categories. The different States were combined into the regions, “SouthWest”, “West”, “NorthEast”, “MidWest”, and “SouthEast”, each signifying the geographical region they represent.

Calculating Default Rates:

Caluculating the Default Rate of the 5 different categories gives the following results; Midwest = 0.1428571, Northeast = 0.1583021, SouthWest = 0.1934325, West = 0.1719593.

## # A tibble: 6 × 2
##   State       Default_Rate
##   <chr>              <dbl>
## 1 ""                 0.143
## 2 "Midwest"          0.158
## 3 "Northeast"        0.161
## 4 "SouthWest"        0.193
## 5 "Southeast"        0.214
## 6 "West"             0.172

Discretize GrAppv:

Here the variable GrAppv is discretized in 5 different buckets, essentially splitting the original population into 5 sub-populations.

Density Curves:

Density curves help to visually represent the distribution of the SBA_Appv values in the data set. The height represents the relative frequency and density of data, while peaks represent areas where the most data is concentrated. Troughs represent the opposite of areas with lower density.

For the first category of SBA_Appv the majority of the data density is around 0, with the rest of the frequency quickly falling off after that. the second group 4 noticible peaks slighlty after the first groups, with the rest of the categories forming wave patterns along the graph.