• Course: Quantitative Analysis Using SPSS
  • Categories : Data Analysis
  • Class Start : April 30, 2020
  • Duration : 10 days (20 hours)
  • Student : Knowledge on Word & Excel
  • Course Fee : 1000/-

Are you Ready to Enroll this Course?

Register Now

About this course

Equip participants with skills in data collection and storage, management, and analysis using computer-based applications like Excel and SPSS.

On successful Completion of this course

Participants will able to:

  • Create and modify large data sets
  • Create and edit graphs, charts and tables in SPSS
  • Statistical Analysis of data in a large project

Target groups:

People who want to be a

  • Researchers,
  • Monitoring and Evaluation Experts
  • Policy Makers
  • NGOs,
  • International Organizations,
  • Students

Course Contents and Schedule

  • Session -1

    1. Understanding Excel sheets and cells
    2. Excel formula: Fixed cell and relative cell address
    3. Creating data using MS excel
    4. Excel random function
    5. Random data generation
    6. Use of conditions in excel
    7. Saving excel file in lower format
    8. Excel data types and cell formatting
  • Session -2

    1. Creating variables of different types
    2. Entering data and saving data files
    3. Export data to another format
    4. Import data from excel
    5. Descriptive statistics including mean median mode
    6. Managing result window
    7. Saving result file
  • Session -3

    1. Construct bar chart, pie chart and scatter diagram
    2. Construct Leaf chart and Box plot and interpretation
    3. Construct bivariate bar chart
    4. Construct bivariate bar chart with descriptive statistics
  • Session -4

    1. Select data for analysis
    2. Partitioning data file
    3. Weighting data file
    4. Joining and merging data files
    5. Aggregate a data file
  • Session -5

    1. Compute new variable/data from existing data
    2. Compute new variable using condition
    3. Recoding an existing variable into different variable or same variable
    4. Labeling of newly created variable
    5. Frequency distribution of a categorical variable
    6. Producing Histogram of a categorical variable
    7. Saving data file for the next day uses
  • Session -6

    1. Editing SPSS output and export to MS Word
    2. Calculate Cross Tables from the data
    3. Calculate Chi-square and interpret the result
    4. Creating SPSS Table for report generation
  • Session -7

    1. Creating report for Multiple Response variable
    2. Correlation, Rank Correlation
    3. Regression
    4. Multiple regression
    5. Logistic Regression and Odds Ratio
  • Session -8

    1. Understanding Inference
    2. One sample t-test
    3. Two sample t-test
    4. Paired t-test
    5. Testing the normality of data
  • Session -9

    1. Understanding Non-parametric test
    2. One-sample Kolmogorov-Smirnov Test for Normality
    3. One-sample Wilcoxon Signed Rank Test for Test of mean
    4. Two independent Samples equality
    5. (Mann-Whitney U test and Kolmogorov-Smirnov)
    6. More than two independent Samples equality (Oneway ANOVA) (Kruskal-Wallis Test)