Dummy Coding with IBM SPSS To understand what is meant by dummy coding, you need to understand 2 forms of data: Qualitative or Quantitative? “Qualitative data describes items in terms of some quality or categorization while Quantitative data are described in terms of quantity (and in which a range of numerical values are used without […]
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
Connect with Jim
Blogs from this Author
Cognos TM1 Attributes -What are They and What Can They Do for Me?
To define an element’s type (numeric, consolidation or string), elements can have attributes defined and assigned to them. What is an attribute you ask? Well, if elements identify data in your cube, then you can think of the element attributes as describing the elements themselves, it’s that simple. For example, let’s say that some of […]
Chi-Squared Challenging using SPSS
Chi-Squared Challenging using SPSS A Chi-Square Challenge (or Test) procedure organizes your data pond variables into groups and computes a chi-square statistic. Here is the specific definition: “The chi-square (chi, the Greek letter pronounced “kye”) statistic is a statistical technique used to determine if a “distribution of observed frequencies” differs from the “theoretical expected […]
IBM SPSS Split File
You can use the IBM SPSS Split File feature to split your data pond into separate groups for further analysis –based on the values of one or more grouping variables. If you select multiple grouping variables, cases are grouped by each variable within categories of the preceding variable on the Groups Based On list. For […]
Simple Inferential Statistics
Simple Inferential Statistics “Inferential statistics” is a term used to describe the use of information regarding a sample of subjects to make: (1) Assumptions about the population at large and/or (2) Predictions about what might happen in the future What’s your Batting Average? You can calculate the mean (or average) batting average of a […]
The IBM SPSS Pivot Table Editor
There are various types of windows in IBM SPSS Statistics: The Data Editor Window – used to manage your data pond. The Viewer Window – where all results of your data analysis are displayed. The Chart Editor Window – here you can change the colors, select different type fonts or sizes, switch the horizontal and vertical […]
IBM SPSS and Frequencies Command
The Frequencies command is one of the simplest yet one of the most useful descriptive techniques. Its objective is to simply sum the number of instances within a particular category. For example, the following questions could be easily answered: How many males and females make up my data pond? What are the number of ethnic […]
Computing New Variables in IBM SPSS
Computing New Variables IBM SPSS Statistics offers more than 70 built-in functions to compute new variables based on your corporate logic. These include: • Arithmetic functions • Statistical functions • Distribution functions • Logical functions • Date and time aggregation and extraction functions • Missing-value functions • Cross-case functions • String functions These functions […]
Ranking your Cases: IBM SPSS Statistics
Ranking A ranking is a relationship between a set of items such that, for any two items, the first is either “ranked higher than”, “ranked lower than” or “ranked equal to” the second. – Wikipedia Ranking in SPSS Statistics IBM SPSS Statistics ranks cases in your data pond by automatically defining new variables to […]
Understanding the SPSS Crosstabs Procedure
The SPSS Statistics Crosstabs procedure forms two-way and multi-way tables (and provides a variety of tests and measures of association for the two-way tables). The structure of the table and whether categories are ordered determine what test or measure to use. Crosstabs’ statistics and measures of association are computed for two-way tables only. If you […]
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 […]
Metadata Attributes
IBM SPSS Statistics offers many ways to help save time when analyzing data, particularly if you are continually performing the same types of analysis on similar sets of pools of data. TIME SAVERS “Metadata Attributes” – Data attributes have properties associated with them, and these properties are defined in metadata. During data analysis, documentation […]