Statistical Data Analysis using Microsoft Excel

Course date: 22/06/2020 to 26/06/2020 Duration: 5 Days Course fee: USD 800, KES 65,000 Registration closed, view 2018 course calender


Enroll for online offer of this course and enjoy a 10% discount!

FineResults Research Services can offer this course as a scheduled virtual class through its seasoned industry experts.

This will not only provides you with an opportunity to train from any location worldwide (including the comfort of your home) but also flexibility in course scheduling.


Course fee: USD 790 or KES 58,500 (online training); USD 800 or KES 65,000 (off-line training)


For more information, talk to us:


Phone: +254 732 776 700 / +254 759 285 295




This course will help improve participants' familiarity with Excel and statistics and as a result increase their effectiveness and efficiency of their research work. The course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. An explanation of Excel limitation and how to overcome them will also be provided.



5 Days



By the end of this training, participants will become knowledgeable in the following:

  • Data management techniques
  • Application of  bivariate techniques in data analysis
  • Appropriate multivariate methods in data analysis
  • Application of various multivariate methods in data analysis
  • Statistical model selection and assessment
  • How to make inferences and conclusions from statistical procedures


Course Outline

Module 1: Descriptive Statistics

Measures of Variability and Central Tendency  

  • Describing quantitative data
  • Describing qualitative data


Excel Graphics

  • Graphing quantitative data
  • Graphing qualitative data


Module 2: Correlation, Chi-square and mean comparison analysis


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



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


Comparing Means

  • Confidence Interval for the Mean
  • Test of Hypothesis Concerning the Population Mean
  • Difference Between Mean of Two Populations
  • One Sample t-tests
  • Paired Sample t-tests
  • Independent Samples t-tests
  •  Comparing Means Using One-Way ANOVA 


Module 3: Aggregating Data in Excel

  • Statistical Functions
  • Outlines
  • Subtotals
  • Pivot Tables


Module 4: Data Relation Analysis

  • Normal Distribution
  • Descriptive Statistics
  • Linear Correlation
  • Regression Analysis
  • Covariance


Module 5: Analysing Data in Time and Forecasting

Analysing Data in Time

  • Trends/Regression line
  • Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
  • Seasonal fluctuations analysis



  • Extrapolation





This training can also be customized for your institution upon request. You can also have it delivered to your preferred location. For further inquiries, please contact us through:

Telephone: +254 732 776 700 or Email: 



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 a study visit (where applicable).



FineResults Research Services arranges accommodation for their clients upon request. For reservations contact us through Telephone: +254732776700

or Email: 



Payment should be transferred to FineResults Research Limited bank before commencement of training. Upon effecting the payment, participants should send scanned 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.



This scheduled training will be held at FineResults Research Training Centre (Nairobi).

Course Date: 22/06/2020 to 26/06/2020 Duration: 5 Days Course fee: USD 800 , KES 65,000
Registration closed, view 2018 course calender
Call us on +254 732 776 700/ +254 759 285 295
Book your Training (Training Calender)
Follow us