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

1

Generating Descriptive Statistics: Frequencies Module

2

Descriptive Module, Explore

3

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

4

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

5

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

6

Paired Sample T Test: Comparing the means of same subject

7

One way ANOVA: Comparing means for more than two groups

8

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

Section 9
##### Introduction to Regression Analysis

1

Doing Simple Regression on SPSS: Understanding the unilinear causality

2

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

3

Example of a Multiple Regression Model

4

Problem of Multicollinearity

5

Methods of Regression: Forced, Forward, Backward, Stepwise

6

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

7

Multiple Regression using SPSS

8

Interpreting Multiple Regression: Parameter Estimate Table

9

Variance Inflation Factor, Collinearity Diagnostics

Section 10
##### Introduction to Logistic Regression

1

Problems related to Logistic regression

2

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

3

Concept of Maximum Likelihood Estimation

4

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

5

Hosmer Lemeshow Goodness of fit test

6

Assessing the Contribution of Predictors: The Wald Statistic

7

Methods of Logistic Regression: Forced Entry Method, Forward LR

8

Classification table: Overall Accuracy

9

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.