Section 1
##### Introducing IBM SPSS Statistics

Section 2
##### Familiarization with the SPSS Data Editor

Section 3
##### Summarizing Individual Variables

Section 4
##### Modifying Data Values

Section 5
##### Graphical Presentation of Data

Section 6
##### Understanding Output in the Viewer

Section 7
##### Helpful Data Management Features

Section 8
##### Statistical Analysis and Tests on SPSS

29

Generating Descriptive Statistics: Frequencies Module

30

Descriptive Module, Explore

31

Checking the distribution: P-P Plots, Q-Q Plots

32

Chi Square test of Independence: Understanding the association between two categorical variables

33

Independent Samples T test: Comparing the means along with variance comparison

34

Paired Sample T Test: Comparing the means of same subject

35

One way ANOVA: Comparing means for more than two groups

36

Two Way ANOVA: Type I and III Sum of Squares, Post Hoc Tests

Section 9
##### Introduction to Regression Analysis

37

Doing Simple Regression on SPSS: Understanding the unilinear causality

38

Interpreting a Simple Regression on SPSS w.r.t. the assumptions of the Regression

39

Example of a Multiple Regression Model

40

Problem of Multicollinearity

41

Methods of Regression: Forced, Forward, Backward, Stepwise

42

Assessing the Regression Model: Goodness of Fit R Square, Adjusted R Square

43

Multiple Regression using SPSS

44

Interpreting Multiple Regression: Parameter Estimate Table

45

Variance Inflation Factor, Collinearity Diagnostics

Section 10
##### Introduction to Logistic Regression

46

Problems related to Logistic regression

47

Nature of Logistic Model: Odds, Odds ratio, Logit Link

48

Concept of Maximum Likelihood Estimation

49

Assessing the Model: The Log-Likelihood Statistic, Cox and Snell’s R Square and Negelkerke R Square

50

Hosmer Lemeshow Goodness of fit test

51

Assessing the Contribution of Predictors: The Wald Statistic

52

Methods of Logistic Regression: Forced Entry Method, Forward LR

53

Classification table: Overall Accuracy

54

Interpreting Logistic Regression

Section 11
##### Introduction to CHAID Decision Tree

Section 12
##### Bivariate Plots and Correlation for Scale Variables

**Introduction to Excel**

MS-Excel is a spreadsheet package developed by Microsoft Corporation. By spreadsheet, we mean that Excel is a computer application for organizing, analysis, storage of data in tabular format. This program operates on data entered in the cells. A user can enter a number or numeric value in the cell and the number will be used for calculation using formulas or functions.

Let’s have a look at the various components of MS-Excel environment:

- Excel is the Spreadsheet application from Microsoft.
- The spreadsheets come as worksheets which belong to a workbook.
- Each worksheet contains rows and columns.
- Each worksheet in Excel 2013 and above has 1,048,576 rows and 16,384 columns.

**Creating Tables Manually in Excel**

In Excel 2007, and later versions, the Table command can be used to convert a list of data into a formatted Excel Table.

Preparing the Data

Before creating an Excel Table, we should follow these guidelines for organizing the data.

- The data should be
**organized in rows and columns**, with each row containing information about one record, such as a sales order, or inventory transaction. - In the first row of the list, each column should contain a short, descriptive and
**unique heading**. - Each column in the list should contain
**one type of data**, such as dates, currency, or text. - Each row in the list should contain the
**details for one record**, such as a sales order. - The list should have
**no blank rows**within it, and no completely blank columns. - The list should be
**separated from any other data**on the worksheet, with at least one blank row and one blank column between the list and the other data.

After your data is organized, as described above, you’re ready to create the formatted Table.

- Select a cell in the list of data that you prepared.
- On the Ribbon, click the Insert tab.
- In the Tables group, click the Table command.
- In the Create Table dialog box, the range for your data should automatically appear, and the
*My table has headers*option is checked. If necessary, you can adjust the range, and check box. - Click OK to accept these settings.

**Renaming an Excel Table**

When it is created, an Excel table is given a default name, such as Table 3. You should change the name to something meaningful, so it will be easier to work with the table later.

To change the table name:

- Select any cell in the table
- On the Ribbon, under the Table Tools tab, click the Design tab.
- At the far left of the Ribbon, click in the Table name box, to select the existing name
- Then, type a new name, such as Orders, and press the Enter key

**Creating an Excel Table With Specific Style**

When you create a table with the Table command on the Ribbon’s Insert tab, the table retains any formatting that it currently has, and the default Table Style is applied.

If you want to apply a specific table style when creating an Excel Table:

- Select a cell in the list of data that you prepared.
- On the Ribbon, click the Home tab.
- In the Styles group, click Format as Table
- Click on the Style that you want to use
- In the Create Table dialog box, the range for your data should automatically appear, and the
*My table has headers*option is checked. If necessary, you can adjust the range, and check box. - Click OK to accept these settings.