Processing and Analyzing Survey and Assessment Data using SPSS Stata and Microsoft Excel

Course Date Onsite fees: Location Register
29/07/2024 To 02/08/2024 1,000 USD, 90,000 Ksh Nairobi
28/10/2024 To 01/11/2024 1,000 USD, 90,000 Ksh Nairobi


Research, Data Management, Graphics & statistical analysis has always been integral parts of development work and has been playing a critical role towards achieving of Sustainable development Goals (SDGs). As a result, knowledge of research methodologies and application of statistical application software's to support data analysis in this era is very important. Statistical Packages for Social Sciences (SPSS), Stata and Microsoft Excel software has proved to be quite useful for the purpose of data management, graphical representation, and statistical analysis of data. These software are user-friendly and reduces the time/efforts that the researcher employ in research. This course aims at equipping participants with knowledge and vast skills which will enable them to use SPSS, STATA and Microsoft Excel in data management, graphics and statistical analysis. At the end of the course, participants will become familiar with using ICT tools and methods to conduct data collection, statistical analysis and reporting.



5 Days



By the end of the training, you will be able to:

  • Understand both descriptive and inferential statistics
  • Understand various data collection techniques and data processing methods
  • Use mobile phones for data collection(Open data Kit)
  • Use basic functions and navigation within Stata and SPSS software
  • Create and manipulate graphs and figures in Stata and SPSS software
  • Handle statistical data analysis tasks in Stata and SPSS software
  • Export the results of your analyses.



Day 1:

Statistical Concepts

  • Statistical Concepts
  • Types of data
  • Data Structures and Types of Variables
  • Overview of SPSS


Statistical Inference

  • Tests of Association
  • Tests of Difference
  • Hypothesis testing


Mobile Data gathering

  • Benefits of Mobile Applications
  • Data and types of Data
  • Introduction to  common mobile based data collection platforms
  • Managing devices
  • Challenges of Data Collection
  • Data aggregation, storage and dissemination
  • Questionnaire Design


Getting started in ODK

  • Types of questions
  • Data types for each question
  • Types of questionnaire or Form logic
  • Extended data types geoid, image and multimedia


Survey Authoring and Preparation of mobile phone for data collection

  • Survey Authoring
  • ODK Collect applications: Installing, Configuring the device (Mobile Phones) and uploading the form into the mobile devices


Designing forms and advanced survey authoring

  • Introduction to XLS forms syntax
  • New data types
  • Notes and dates
  • Multiple choice Questions
  • Multiple Language Support
  • Hints and Metadata


Advanced survey Authoring

  • Conditional Survey Branching
    • Required questions
    • Constraining responses
    • Skip: Asking Relevant questions
    • The specify other
  • Grouping questions
    • Skipping many questions at once (Skipping a section)
  • Repeating a set of questions
  • Special formatting
  • Making dynamic calculations


Hosting survey data (Online)

  • ODK Aggregate
  • Uploading the questionnaire to the server


Day 2:

Introduction to SPSS/Stata/Excel

  • Installing the software(s)
  • Software interfaces
  • Working with the software (file management, editing functions, viewing options, etc)
  • Output Management
  • Basics programming of Stata and SPSS


Data Entry/Management

  • Entering categorical and continuous data
  • Defining and labeling variables
  • Validation and Sorting variables
  • Transforming, recording and computing variables
  • Restructuring data
  • Replacing missing values
  • Merging files and restructuring
  • Splitting files, Selecting cases  and weighing cases
  • Syntax and output


Descriptive Statistics

Measures of Variability and Central Tendency  

  • Describing quantitative data
  • Describing qualitative data


Graphics in Data Analysis

  • Graphing quantitative data
  • Graphing qualitative data
  • Advanced graphics options


Day 3:

Quantitative Data Analysis (Part I)


  • Correlation of bivariate data
  • Subgroup Correlations
  • Scatterplots of Data by Subgroups
  • Overlay Scatterplots


Comparing Means

  • One Sample t-tests
  • Paired Sample t-tests
  • Independent Samples t-tests
  • Comparing Means Using One-Way ANOVA 


Comparing Means Using Factorial ANOVA 

  • Factorial ANOVA Using GLM Univariate
  • Simple Effects


Comparing Means Using Repeated Measures ANOVA 

  • Using GLM Repeated Measures to Calculate Repeated Measures ANOVAs
  • Multiple Comparisons


Module 5: Quantitative Data Analysis (Part III)


  • Goodness of Fit Chi Square All Categories Equal
  • Goodness of Fit Chi Square Categories Unequal
  • Chi Square for Contingency Tables


Day 4:

Quantitative Data Analysis (Part II)

Regression Analysis

  • Assumptions of selected types of regression
  • Linear regression; Binary logistic regression; ordered logistic regression; multinomial logistic regression and Poisson regression
  • GLM Model
  • The Problems with regression


Nonparametric Statistics 

  • Mann-Whitney Test
  • Wilcoxon’s Matched Pairs Signed-Ranks Test
  • Kruskal-Wallis One-Way ANOVA
  • Friedman’s Rank Test for k Related Samples


Day 5:

Quantitative Data Analysis (Part III)

Survey estimation and inference for complex designs

  • Introduction to survey data
  • Introduction to complex sample designs, survey estimation and inference
  • Multi-stage designs, stratification, cluster sampling, weighting, item missing data, finite population corrections
  • Models and assumptions for inference from complex sample survey data
  • Sampling distributions, confidence intervals
  • Design effects.


Advanced analysis of complex survey data

  • Bayesian Analysis of Complex Sample Survey Data
  • Generalized Linear Mixed Models (GLMMs) in Survey Data Analysis
  • Fitting Structural Equation Models to Complex Sample Survey Data
  • Small Area Estimation and Complex Sample Survey Data
  • Nonparametric Methods for Complex Sample Survey Data 





This training can also be customized for your institution upon request. You can also have it delivered your preferred location. For further inquiries, please contact us through Mobile: +254 732 776 700 or +254 759 285 295. You can also email us on:



Participants should be reasonably proficient in English.  During the trainings, participants should come with their own laptops.



The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.



Accommodation is arranged upon request. For reservations contact us through Mobile: +254 732 776 700/+254 759 285 295 or Email:



Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email:



  • All requests for cancellations must be received in writing.
  • Changes will become effective on the date of written confirmation being received.


Call us on +254 732 776 700/ +254 759 285 295
Book your Training (Training Calender)
Follow us