Scoring a model in SPSS

In the previous post "predicting payment days for accounts receivables at hospitals", we created several model nuggets that could predict the payment days based on inputs such as age, income, employment, marital status, etc and on the observed values of the actual number of days that we taken for payment.  In today's post, we will use one of those model nuggets to to predict the number of days for a new set of data.  This process, called "scoring the model" in SPSS is really the main objective of the entire modeling exercise.

In order to do this, we first need a new set of data that contain the same fields as the data that was used in developing the model.  An easy way to test this is by using the same file that was used to train the model but removing the observed data from the file.  From the image below, you will see that the field "payment days" is missing:


We then run this data through the Auto Data Prep node.  This is important because we used the Auto Data Prep node while creating the model nugget and the model nugget will look for all the same fields while attempting to score the model.  We also run the data through the Anomaly node for the same reason.

We then attach a filter node to the anomaly node and remove the following input fields since they are not needed for the prediction:


We then attach a select node to remove all the records that have anomalies in them.  Having removed the anomalies, we attach a type node where all the fields are treated as inputs - none of the fields are designated as the target.  We are now ready to run this data through the model nugget that we had created using the observed values of payment days.

In order to do that, we copy the model nugget from the original stream and paste it on our current modeling canvas.  We then attach a table node to the model nugget and run the table node.  The results are as follows:


As can be seen from the image above, the right-most column of the table contains a field called $R-payment days.  This field is generated by the model nugget and contains the models predictions for the number of payments days.

Comments

Post a Comment

Popular posts from this blog

AI, ML, NN and DL: a visual explanation

Image
There appears to be a lot of confusion between the terms Artificial Intelligence (AI), Machine Learning (ML), Neural Networks (NN) and Deep Learning (DL).  Based on research from various popular blogs and articles, here is my attempt at a simple visual explanation:
Read more

Understanding And Interpreting Gain And Lift Charts

Image
Lift and Gain Charts are a useful way of visualizing how good a predictive model is. In SPSS, a typical gain chart appears as follows: In today's post, we will attempt to understand the logic behind generating a gain chart and then discuss how gain and lift charts are interpreted. To do this, we will use the example of a direct mailing company. Let us assume that based on experience, the company knows that the average response rate on its direct mail campaigns is 10%. Let us further make the following assumptions: * Cost per ad mailed = $1 * Return per response = $50 Additionally, let us assume that the company mails out ads in lots of 10,000. Based on these assumptions, if the company mails out 100,000 ads, a table summarizing the results it would obtain from this campaign is provided below: Now let us assume that the company uses SPSS Modeler to develop a predictive model using data from previous campaigns. "Response / No Response" is identified as the ...
Read more

Creating a time series forecast using IBM SPSS Modeler

Image
In today's post, we discuss how to create a time series forecast using IBM SPSS Modeler.  For the purposes of our exercise, we will use historical sales data at a SKU (stock keeping unit) level.  This data is provided in a MicroSoft Excel .xlsx file and must be in the following format: In the image above, AAAAA through EEEEE are SKU numbers with the relevant monthly sales data provided in the respective columns.  There is also a column that indicates the grand total of all SKUs sold in a month (AAAAA +...+ EEEEE + other SKUs not shown in the image above).  The last column in the image above reflects the months for which historical sales data are provided. As with any modeling exercise, we first insert a source node into the modeling canvas.  Since our data is in the MicroSoft Excel .xlsx file format, we insert an Excel source node as follows: On exporting to a Table node, we see the output display as follows: We then add a Filter node to select t...
Read more