INTRODUCTION
This course is
about Statistics and Data Analysis. The course will teach you the advanced
concepts related to Statistics and Data Analysis, and help you in applying
these concept. Various examples and data-sets will be used and then we will
show you how to use Microsoft Excel to perform these calculations.
COURSE
OBJECTIVES
At the end of course participants should be able to:
DURATION
5 Days
WHO
SHOULD ATTEND
The course
targets Statistician, analyst, or a budding data scientist and beginners
who want to learn how to analyze data with excel.
COURSE
CONTENT
·
Statistics Introduction and
Definitions
·
Types of Data in Excel - Text,
Numbers, Date/Time, Logical
·
Qualitative vs
Quantitative Data / Continuous vs Discrete
·
Nominal, Ordinal, Interval &
Ratio
·
Population and Sample (Theory)
·
Understanding Data Types
·
Understanding Formulas and Functions
·
Relative vs Absolute Reference
·
Formulas, Functions and Named Ranges
·
Descriptive Statistics
·
Section Introduction - Descriptive
Statistics
·
Descriptive Statistics - Central
Tendency
·
Descriptive Statistics - Variation
·
Installing Data Analysis Pack and
Calculating Descriptive Statistics
·
Descriptive Statistics - Central
Tendency
·
Descriptive Statistics - Variation
(Excel)
·
Descriptive Statistics - Shapes
·
Descriptive Statistics
·
Data Visualization
·
Three commonly used Charts
·
Create Histogram
·
Histogram Shapes
·
Create Box and Whisker Plot
·
Scatter Diagram
·
Create Scatter Plot
·
Data Visualization
·
Introduction to Basic Probability
Concepts
·
Basic Probability Concepts
·
Calculate Factorial, Permutations
and Combinations
·
Basic Probability Concepts
·
Probability Distributions
·
Central Limit Theorem Demonstration
·
Normal Probability Distribution
·
Binomial Probability Distribution
·
Other Distributions Related to
Binomial Distribution
·
Poisson Distribution
·
Probability Distributions
·
Introduction Hypothesis Testing
·
Hypothesis Testing - Types of Errors
·
Hypothesis Testing Explained
·
Tests for Mean, Variance and
Proportions
·
One Sample z Test
·
Two Tail Example
·
Understanding the p Value
·
Introduction to T Functions
·
One Sample t Test - Example
·
One Sample p Test
·
Two Sample z Test
·
Two Sample t Test - Equal Variance
·
Two Sample t Test - Unequal Variance
·
Two Sample t Test - Paired t Test
·
Two Sample p Test
·
Introduction Tests for Variance (F
and Chi Square)
·
F Test to Compare Variances
·
Plotting F Distribution
·
F Distribution Related Functions
·
F.TEST Function
·
F Test Using Data Analysis Pack
·
Chi Square Test for Variance
·
Plotting Chi Square Distribution
·
Chi Square Distribution Related
Functions
·
Chi Square Test
·
Introduction to ANOVA
·
Understanding the concept of ANOVA
·
Formulas and calculations in ANOVA
·
Performing ANOVA
·
Two Factor ANOVA without Replication
·
Two Factor ANOVA with Replication
·
Goodness of Fit and Contingency
Table
·
Introduction Goodness of Fit and
Contingency Tables
·
Goodness of Fit Test
·
Contingency Table
·
Correlation and Linear Regression
·
Introduction to Correlation
·
Plotting Scatter Plot and
Calculating Correlation Coefficient
·
Correlation Coefficient for Multiple
Variables
·
Correlation Related Functions
·
Correlation vs Causation
·
Coefficient of Determination
·
Manual Calculation
·
Slope, Intercept
·
Forecast, Linear, Trend & Linest
·
Regression using Data Analysis Pack
GENERAL
NOTES
·
This course is delivered by our seasoned trainers who have
vast experience as expert professionals in the respective fields of practice.
The course is taught through a mix of practical activities, theory, group works
and case studies.
·
Training manuals and additional reference materials are
provided to the participants.
·
Upon successful completion of this course, participants will
be issued with a certificate.
·
We can also do this as tailor-made course to meet
organization-wide needs. Contact us to find out more: training@skillsforafrica.org
· The training will be conducted at SKILLS FOR AFRICA TRAINING INSTITUTE IN NAIROBI
KENYA.
· The training fee covers
tuition fees, training materials, lunch and training venue. Accommodation and
airport transfer are arranged for our participants upon request.
·
Payment should be sent to our bank account before start of
training and proof of payment sent to: training@skillsforafrica.org
Dates | Fees | Location | Apply |
---|---|---|---|
14/10/2024 - 18/10/2024 | $2950 | Kigali | Physical Class Online Class |
11/11/2024 - 15/11/2024 | $1500 | Mombasa | Physical Class Online Class |
09/12/2024 - 13/12/2024 | $1500 | Nairobi | Physical Class Online Class |