Email Me | Resume | Home Page | Publications | SAS Code | VB6 Code

Title Miscellaneous Downloads
Miscellaneous Downloads

This section offers some PowerPoint Slides, Word Documents, Excel Spreadsheets, and items not otherwise categorized as SAS Code or VB6 Code. As always, I have to say that these downloads are without warranty and I accept no liability for their use or installation.

Survey of Scoring Techniques

This is an excellent discussion of credit scoring techniques covering topics such as logistic regression, probit regression, neural nets, CART, incorporating economic indictors in models, profitability scoring, and behavior scoring. At the end of the article, the author provides a comprehensive list of references.

Stress Test Simulator in SHAZAM

This is a program written in SHAZAM that estimates a Pooled Cross Section Time Series Model and simulates the result of a change in employment. The example used does not represent real data, but is shown for illustration purposes only.

LifeCast Pro Manual

This is a summary manual for LifeCast Pro for new product forecasting. Even if you are not interested in purchase, the information provided here may prove interesting.

New Product Diffusion Article

This is a good 2004 article about forecasting new product launches using diffusion theory.

LifeCast Pro software update

This is an upgrade to LifeCast Pro software. It requires a previous version to be already loaded on your computer.

The Bass Diffusion Model

This is an Excel file showing you how to develop the Bass model in a spreadsheet. The Bass Model is often used for forecasting a new product or service.

Case Study in New Product Forecasting

This document discusses an approach to new product forecasting using the Bass Diffusion Model and a simulation procedure through Logistic Regression.

Neural Net Primer

If you have a background in regression and want to learn about neural nets, this paper is for you. It gives a discussion of neural nets from an econometrics perspective through a question and answer format. Very useful.

Credit Modeling

This is an informative discussion of credit modeling that serves as a good introduction to different best practices in the industry.

New Product Forecasting Presentation

This is a powerpoint presentation discussing new product forecasting techniques. It was presented at the IBF conference in 2002.

Forecasting Dictionary

Here is a dictionary of forecasting terms that is great for including in documentation and reports.

Reject Inferencing

This is a discussion of a technique often used in credit scoring to enhance model accuracy. The paper serves as a good introduction to the subject.

Reject Inferencing

This paper presents some research that shows reject inferencing is not that bad a problem if you can increase your sample size as is possible in credit card modeling. This is an excellent paper and worth reading with practical implications concerning reject inferencing.

Tobit Alternative: Beta Transform

Here is an Excel spreadsheet showing the transformation process where you can more appropriately apply linear regression. Some say you can use this method where the dependent variable is clustered around upper or lower boundaries. This is seen by some as an alternative to using a Tobit Model. This procedure is used by Moody's to estimate their LOSSCALC recovery model.

Understanding Basel II in Banking

Here is a great summary of the Basel II regulatory requirements that will be imposed on many of the larger banks in the U.S. and worldwide, scheduled to go into effect in 2007. It requires banks to risk rate ALL their loans in order to reduce their capital requirements.

Good paper on Credit Risk

Very good summary of History of Credit Risk - mostly consumer based.

Link to Economic Time Series Data

Good link to Economic data for Modeling - FREE!

SAS Code References for BootStrapping

Link to SAS code for Bootstrapping

ROC Curve Calculations

Here is a method for numerically calculating the area under the ROC curve which is often used to determine the accuarcy of credit scoring models.

Dymnamically Writing SAS Code

Here is a paper that describes how to use SAS to dynamically write out SAS code. I have put example code of this type in my SAS download section, but this paper should give a more detailed discussion of this very important concept.

CART and Logistic Regression

This is a powerpoint presentation on how to integrate logistic regression with C.A.R.T. modeling. Makes sense!

Survival Analysis

This is a good practical discussion of Survival Analysis in SAS.

Survival Analysis

This is another good practical discussion of Survival Analysis in SAS. Focus here is Telecommunications.


SAS has a new procedure called PROC QLIM which can be used for a number of different types of models including discrete choice and Tobit Regression.

Hybrid Modeling Platform

This is a powerpoint presentation describing a modeling platform combining VB6 and SAS. This was presented in St. Pete Florida at the 2003 SEUG conference in September.

Value of Economic Data

This is a paper presented in the RMA Journal on the role of Economic Data and its usefulness in Credit Modeling (by Jiong Liu & Xiaoqing Eleanor Xu).

SHAZAM Double Tobit

This is the programming code, data file, and output for a double sided tobit model in SHAZAM which will match the output from the SAS double sided tobit model using PROC QLIM that can be obtained from my SAS download page.

SHAZAM Examples by Greene

This is a link to SHAZAM programs written to illustrate William Greene's textbook 'Econometric Analysis' published in 2000. Great resource for econometric analytics!

Portfolio Stress Testing

Good article on portfolio stress testing.

Portfolio Stress Testing

Good article on portfolio stress testing.

Portfolio Stress Testing

Using Pooling in Portfolio Stress Testing.

Vintage Analysis and Macroeconomics

Vintage Analysis for Mortgage Loans.

Macroeconomic Modeling

Economic Modeling in Risk Models.

Portfolio Forecasting

This article compares PD modeling vs. Portfolio modeling using economic data.

Loss Forecasting Techniques

This article reviews different loss forecasting techniques such as roll rates, econometrics, vintages.

Overview Of Credit Modeling

This article is a good nontechnical overview of modeling credit data over the entire lifecycle.

Basel II Modeling

This article is a good technical discussion of modeling Basel PD, LGD, EAD and stress testing. I personally do not agree with trying to incorporate economic data directly in those models, but here is another view.

Explaining Basel II & III

Good summary of Basel as of 2011.

Logistic Regression in Excel

You can now do logistic regression in Excel.

Leading Credit Indices

A good article by the conference board on the development of a leading credit index - soup to nuts.

Impact of Adding a Lagged Dependent Variable

Great article examining what bad things can happen if you add a lagged dependent variable into your regression equation. It can swamp your other variables if there are trends.

Forecasting implications of log transformations

Good article looking at the impact of log transformations in forecasting accuracy. End result - no harm done.

Differencing or Levels in Forecasting

The original article on the subject in 1974. Different schools of thought exist, but they are leaning towards differencing today.

Binning Numeric Variables

This is a VBA spreadsheet program which allows the user to interactively produce and collapse bins for modeling purposes. When you pull it up, resave as a .xlsm file. It also contains a Correlation macro using Excel's Data Analysis Toolkit. The macro computes pairwise and bivariate correlations and warns users if multicollinearity problems might exist given certain correlation thresholds.

Binning Categorical Variables

This is a VBA spreadsheet program which allows the user to interactively produce and collapse bins for modeling purposes. When you pull it up, resave as a .xlsm file.

Good Econometric article long run stationarity in forecasting

Article discusses that when looking at long run trends, it is important to test for stationarity. Examples include GDP, Industrial Production, and Employment.

How to test differences in proportions

This is a handy spreadsheet I found that shows you the Excel calculations to test the difference between 2 proportions.

Omega Replica Watches Cheap Breitling Replica Breitling Replica Watches Breitling Replica UK Cheap Omega Replica Luxury Replica Watches Fake Watches Cheap Rolex Replica Cheap Rolex Rolex Replica Watches