Sunday, December 02, 2012

Build a Scorecard in Oracle Using Logistic Regression Model

One of the popular methods in assessing credit risk is a scorecard. To build a scorecard manually, analysts first identify a number of relevant variables, e.g. having bankruptcies in the past, number of open accounts, etc. Each variable is divided into meaningful segments based on its value. Then a point is assigned to each segment. The credit score is the sum of the points for all the variables. For example, a scorecard may look like the following:

Variable | Segment | Point
Having Bankruptcy | NO | 95
Having Bankruptcy | YES | 15
Number of Open Accounts | from 1 to 3 | 30
Number of Open Accounts | from 4 to 8 | 50
Number of Open Accounts | 9 or more | 40
...................................................

Assume a person's credit history shows past bankruptcy, 4 open accounts and other information. His credit score will be calculated as 15+50.....

To determine the points manually is subjective. A much better way is to build a logistic regression model and use the model coefficients as the "points". A scorecard created this way is accurate and yet still provides the transparency of a scorecard. One of the top cell phone service provider actually used our model-derived scorecard to screen the new customers.

In example 2 of the post Build Predictive Models Using PL/SQL, we show how to build a logistic regression model in Oracle. The extract the model coefficients, we simply use the following query:

select attribute_name, attribute_value, coefficient from table(select dbms_data_mining.get_model_details_glm('GLM_MODEL') from dual);
(Replacing 'GLM_MODEL' with real model name)

We may want to perform some transformation of the coefficients so that the score will be within the desired range.

5 comments:

justin adams said...

Content is that the king and well written content not solely attract customers however conjointly facilitate in obtaining high rankings on the main search engines like Google, MSN and Yahoo. Therefore, it becomes vital to decide on a expert content author to put in writing the content of your web site or promoting materials. There square measure several freelance writers accessible on World Wide Web United Nations agency square measure giving glorious freelance writing services at cheap costs here essay writing service uk.

Betty Lane said...

La quantità di essere risarciti per la piattaforma fiscale è acquisita mediante l'attuazione di una quantità di three,90%. Recentemente and apertura partita iva, per poter realizzare microimprese sono stati presentati in global organization modo di diminuzione della piattaforma imposta mediante riduzione.

Katherine Hayden said...
This comment has been removed by a blog administrator.
caren said...

I am not well-aware about it, but I know that www.best-custom-essays.com can prepare any type of paper ;)

Brenda Thomson said...

Biulding a logistic regression is always the problem for me, so thank you for informing on the topic. As I know, grand-essays writing service can help complete quality assignments on any topic.