We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Microsoft Excel is a very powerful tool for statistical data analysis. In fact there are numerous instances when a data analyst does not require to use other specialized data analysis software such as SPSS, Stata, R, etc, as long as they have access to Microsoft Office Excel. This course will help improve participants' familiarity with Excel statistical functions and hence achieve great effectiveness and efficiency in research. The course describes how to use the Analysis ToolPack in Microsoft Excel, numerous statistical functions and data management techniques as applicable in most research endevours. An explanation of Excel limitation and how to overcome them will also be provided. Keen attention would be made in guiding participants on how to present results from Microsoft Excel data analysis as well as writing research reports.

COURSE SUMMARY
Course date:
05/08/2019 to 09/08/2019
Duration: 5 Days
Course fee: USD 800, KES 65,000

Outline

INTRODUCTION

Microsoft Excel is a very powerful tool for statistical data analysis. In fact there are numerous instances when a data analyst does not require to use other specialized data analysis software such as SPSS, Stata, R, etc, as long as they have access to Microsoft Office Excel. This course will help improve participants' familiarity with Excel statistical functions and hence achieve great effectiveness and efficiency in research. The course describes how to use the Analysis ToolPack in Microsoft Excel, numerous statistical functions and data management techniques as applicable in most research endevours. An explanation of Excel limitation and how to overcome them will also be provided. Keen attention would be made in guiding participants on how to present results from Microsoft Excel data analysis as well as writing research reports.

 

DURATION

5 Days

 

COURSE OBJECTIVES

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

  • Data management techniques using Microsoft Excel
  • Descriptive statistics and methods of results interpretation and presentation.
  • Multivariate methods of data analysis and subsequent methods of results interpretation and presentation.
  • Selection of appropriate statistical model.
  • How to present/communicate data analysis results.

 

Course Outline

Module 1:

Data management in Microsoft Excel

  • Organizing data for analysis
  • Computing new variable information

 

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  

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

 

Chi-Square 

  • 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

 

Forecasting

  • Extrapolation

 

 

***************************

TRAINING CUSTOMIZATION

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: [email protected]

 

REQUIREMENTS

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

 

TRAINING FEE

The course fee covers the course tuition, training materials, two break refreshments, lunch and a study visit (where applicable).

 

ACCOMMODATION

FineResults Research Services arranges accommodation for their clients upon request. For reservations contact us through Telephone: +254732776700 or Email: [email protected]

 

PAYMENT

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: [email protected]

 

CANCELLATION POLICY

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

 

TRAINING VENUE

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

Schedules

Reviews
Be the first to write a review about this course.
Write a Review

FineResults Research Ltd offers training solutions to individuals, communities, governments and civil society organizations, both local and international.

We also provide application-oriented and field-based consultancy services in all aspects of research and evaluations from inception to completion. This includes research designs, designing monitoring and evaluations systems, technical reviews, programme evaluations, questionnaire validation, data collection, data capture, data analysis and report writing. FineResults Research Ltd Services is a limited company incorporated under the laws of Kenya. Its head office is in Nairobi Kenya.

The organization has a wide range of experience working with both local and international organizations in both consultancies and capacity building in Africa and beyond.

Mission

A world class training and research organization for the realization of individuals, organizations and community welfare.

Vision

To provide world class training and research services that increase individuals and organizations productivity in their development role.

Our Value Statement
  • We cherish partnerships.
  • We believe that our Training and Research Solutions can re-energise organisations by creating vision, certainty and strategic intent. ...
FineResults Research Services
nairobi, Nairobi, Kenya
0732 776 700
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.