Skip to main content

Data & Intelligence

SPSS Codebook

A  codebook is a type of document used for gathering and storing codes. Originally codebooks were often literally books, but today codebook is a byword for the complete record of a series of codes, regardless of physical format. – Wikipedia

The codebook command was introduced in IBM SPSS Statistics version 17. It provides information about the variables in a data pool, such as the type, variable labels, value labels, as well as the number of cases in each level of categorical variables and means and standard deviations of continuous variables. This information can be as important as the data themselves, because it helps to give meaning to the data.

 

You can access the codebook dialog via the SPSS menu by clicking on:

Analyze -> Reports -> Codebook.

Codebook Variables Tab

The Variables tab allows you to select one or more variables and/or multiple response sets.

Codebook Output Tab

The Output tab controls the variable information included for each variable and multiple response set, the order in which the variables and multiple response sets are displayed, and the contents of the optional file information table.

Codebook Statistics Tab

The Statistics tab allows you to control the summary statistics that are included in the output, or suppress the display of summary statistics entirely.

Codebook Results

Once you run your codebook all of the output (based upon your selections) is displayed in the IBM SPSS Viewer “results pane”, where it can be reviewed and/or formatted for presentation. The codebook “default output” includes:

• Variable information for all variables in the data pool, except for reserved system attributes.

• Counts and percents for all categories of nominal and ordinal variables, labeled categories of scale variables, and multiple response sets.

• Mean, standard deviation, and quartiles for scale variables.

 

Recommendations

Take full advantage of SPSS Codebook to document each data pool used in your predictive analysis and expect the same for any predictive professional you do business with. It is considered a “best practice” prerequisite.

 

 

 

Have a great Week!

“It must be jet lag. My emotions are getting the best of me…” – Emily Reed

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Jim Miller

Mr. Miller is an IBM certified and accomplished Senior Project Leader and Application/System Architect-Developer with over 30 years of extensive applications and system design and development experience. His current role is National FPM Practice Leader. His experience includes BI, Web architecture & design, systems analysis, GUI design and testing, Database modeling and systems analysis, design, and development of Client/Server, Web and Mainframe applications and systems utilizing: Applix TM1 (including TM1 rules, TI, TM1Web and Planning Manager), dynaSight - ArcPlan, ASP, DHTML, XML, IIS, MS Visual Basic and VBA, Visual Studio, PERL, Websuite, MS SQL Server, ORACLE, SYBASE SQL Server, etc. His Responsibilities have included all aspects of Windows and SQL solution development and design including: analysis; GUI (and Web site) design; data modeling; table, screen/form and script development; SQL (and remote stored procedures and triggers) development and testing; test preparation and management and training of programming staff. Other experience includes development of ETL infrastructure such as data transfer automation between mainframe (DB2, Lawson, Great Plains, etc.) systems and client/server SQL server and Web based applications and integration of enterprise applications and data sources. In addition, Mr. Miller has acted as Internet Applications Development Manager responsible for the design, development, QA and delivery of multiple Web Sites including online trading applications, warehouse process control and scheduling systems and administrative and control applications. Mr. Miller also was responsible for the design, development and administration of a Web based financial reporting system for a 450 million dollar organization, reporting directly to the CFO and his executive team. Mr. Miller has also been responsible for managing and directing multiple resources in various management roles including project and team leader, lead developer and applications development director. Specialties Include: Cognos/TM1 Design and Development, Cognos Planning, IBM SPSS and Modeler, OLAP, Visual Basic, SQL Server, Forecasting and Planning; International Application Development, Business Intelligence, Project Development. IBM Certified Developer - Cognos TM1 (perfect score 100% on exam) IBM Certified Business Analyst - Cognos TM1

More from this Author

Follow Us