Statistical Data Analysis Using Microsoft Excel
Details
FineResults Research Services would like to invite you to take part in our upcoming workshops on Research Courses at our FineResults Research Services training facilities in Nairobi, Kenya or online.
29/01/2024-02/02/2024 Statistical Data Analysis Using Microsoft Excel
29/04/2024-03/05/2024 Statistical Data Analysis Using Microsoft Excel
29/07/2024-02/08/2024 Statistical Data Analysis Using Microsoft Excel
28/10/2024-01/11/2024 Statistical Data Analysis Using Microsoft Excel
Introduction
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.
Duration
5 Days
Course Objectives
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
- 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 Fee
Cost:
In-person USD 1000
Registration
January in-person/online
April in-person/online
Julyin-person/online
October in-person/online
Training Customization
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 or email.
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 study visits.
Accommodation
Accommodation is arranged upon request. For reservations contact us through mobile or email.
Payment
Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email.
Cancellation Policy
- All requests for cancellations must be received in writing.
- Changes will become effective on the date of written confirmation being received.
Schedules
Weekdays | 08:30 AM — 04:30 PM |
Weekdays | 08:30 AM — 04:30 PM |
Weekdays | 08:30 AM — 04:30 PM |
Weekdays | 08:30 AM — 04:30 PM |
No. of Days: | 5 |
Total Hours: | 40 |
FineResults Research Services 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 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.
MissionA world class training and research organization for the realization of individuals, organizations and community welfare.
VisionTo 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. ...