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 Objective:
· Descriptive
and Inferential Statistics.
· Statistical
calculations.
· understand
statistics from basic to advance using excel
Duration
5days
Who should attend?
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
·
All our courses can be
Tailor-made to participants needs
·
The participant must be
conversant with English
·
Presentations are
well guided, practical exercises, web-based tutorials, and group work. Our
facilitators are experts with more than 10years of experience
·
Upon completion of
training, the participant will be issued with a Global King Project Management
certificate
·
Training will be done at
the Global King Project Management Centers (Nairobi Kenya, Mombasa Kenya,
Kigali Rwanda, Dubai ,Lagos Nigeria and More others).
·
A discount of 20% will
be given to more than 4 participants from same organization.
·
Course duration is
flexible and the contents can be modified to fit any number of
days.
·
Payment should be done
before commencement of the training, to the Global King Project Management
account, so as to enable us to prepare better for you.
·
For any inquiry
to: [email protected] or +254 114 830 889
·
Website: www.globalkingprojectmanagement.org
·
Tablet and Laptops are
provided to participants on request as an add-on cost to the training fee
·
The course fee for
onsite training includes facilitation training materials, 2 coffee breaks, a
buffet lunch, and a Certificate of successful completion of Training.
Participants will be responsible for their own travel expenses and
arrangements, airport transfers, visa application dinners, health/accident
insurance, and other personal expenses.
Start Date | End Date | Action | Duration | Location | Fee(Kes) | Fee(Us$) |
---|---|---|---|---|---|---|
23/01/2023 | 27/01/2023 | 5Days | Nairobi | 100000 | 1200 | |
20/02/2023 | 24/02/2023 | 5Days | Nairobi | 100000 | 1200 | |
20/03/2023 | 24/03/2023 | 5Days | Nairobi | 100000 | 1200 | |
12/06/2023 | 16/06/2023 | 5Days | Nairobi | 100000 | 1200 | |
10/07/2023 | 14/07/2023 | 5Days | Nairobi | 100000 | 1200 | |
04/09/2023 | 08/09/2023 | 5Days | Nairobi | 100000 | 1200 | |
02/10/2023 | 06/10/2023 | 5Days | Nairobi | 100000 | 1200 | |
27/11/2023 | 01/12/2023 | 5Days | Nairobi | 100000 | 1200 | |
17/04/2023 | 21/04/2023 | 5Days | Mombasa | 120000 | 1500 | |
15/05/2023 | 19/05/2023 | 5Days | Mombasa | 120000 | 1500 | |
07/08/2023 | 11/08/2023 | 5Days | Mombasa | 120000 | 1500 | |
30/10/2023 | 03/11/2023 | 5Days | Mombasa | 120000 | 1500 |