Workshop on SPSS & Excel

Summary:

• Introduction
• Data Processing
• Data Analysis
• Descriptive Statistics
• Measures of Dispersion
• Distribution
• Inferential Statistics
• Correlation Analysis
• Regression Analysis
• Statistical Test
• Analysis of Variance (ANOVA)

Details of program

Introduction

• SPSS
• Statistics
• Interrelationship between SPSS and Statistics

Data Processing

• Data Coding
• Data Sheet Creating
• Data Entry
• Data Cleaning

Data Analysis

Descriptive Statistics

1. Univariate Table: Frequency Table
2. Bi-variate and Multivariate Table
3. Measures of Central Tendency

• Mean
• Median
• Mode
• Quartile
• Percentile

Measures of Dispersion

• Range
• Standard Deviation

Distribution

• Skewness
• Kurtosis

Inferential Statistics

Correlation Analysis

•  Pearson’s Correlation Coefficient
• Spearman Correlation Coefficient

Regression Analysis

• Two Variables Regression
• Multiple Regression

Statistical Test

• Chi-square Test
• T- Test
• Z- test

Analysis of Variance (ANOVA)

• One-way ANOVA
• Two-way ANOVA