Quantity will be replaced by the Quantity_New attribute for data analysis and modelling.Ģ. Notice that all attributes except Quantity have 84672 records. Run the Data Audit again to check whether Nulls has been replaced by Mean value.
![spss modeler 18 spss modeler 18](http://5b0988e595225.cdn.sohucs.com/images/20170706/d374b1d6c4c84c2f965d824f8ffb5cfe.png)
Replace the Nulls with Mean value for the newly created variable. Here a new attribute named Quantity_New is created to convert the data type from integer to real number. The numerical columns should be real numbers. Select the Filler node from the Field Ops Palette and then select the Set Globals node from the Output palette to find the mean of multiple attributes. The next action is to replace the nulls with mean values for respective attributes. The screenshot below shows the total number of obs is 84672 and the attributes Revenue and below have only 24743 valid records and the remaining are nulls. The Data Audit node helps to identify how many valid records exist along with basic statistics. The third action is to select the Data Audit node from the Output palette. Select the radio button to the right of the file and navigate to the folder where the data file is saved. The next action is to read the data in SPSS. The Var.File option is used for reading csv files, text files, etc. Select the Var.File node under Sources palette with the drag-and-drop method onto the SPSS Modeler Interface.
![spss modeler 18 spss modeler 18](https://pictures-nigeria.jijistatic.com/70959766_NjAwLTYwMC05OWYwNWY0N2Iw.jpg)
This is the first step in the SPSS stream. The nodes are selected, manipulated and connected to the subsequent nodes by right-clicking on each node and pressing Connect to move to the next node. This sequence of operations is known as a data stream because the data flows record by record from the source through each manipulation and, finally, to the destination either a model or type of data output.
SPSS MODELER 18 SERIES
SPSS MODELER 18 WINDOWS 7
This tutorial was tested on Windows 7 using IBM SPSS Modeler v18.1.
![spss modeler 18 spss modeler 18](https://cdn.cupdf.com/img/1200x630/reader025/reader/2021050511/585ca73e1a28abed218f41bd/r-1.jpg)
You can explore your data, fitting different models and investigating different relationships, until you find useful information. In contrast to more traditional statistical methods, you do not necessarily need to know what you are looking for when you start. As a data mining application, IBM SPSS Modeler offers a strategic approach to finding useful relationships in large data sets.