Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

# Training Course On Data Analysis Modeling And Simulation Using Excel

## By: Data-Afrique Consultants

Kenya

12 - 16 Aug, 2024  5 days

### USD 2,950

Venue: Nairobi

Other Dates

Venue Date Fee
Nairobi, Kenya 09 - 13 Sep, 2024 USD1500
Kigali, Rwanda 14 - 18 Oct, 2024 USD2950
Mombasa, Kenya 11 - 15 Nov, 2024 USD1500
Nairobi, Kenya 09 - 13 Dec, 2024 USD1500

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 concepts. Various examples and datasets 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:

• Understand descriptive and Inferential Statistics.
• Understand statistical calculations.
• Understand statistics from basic to advance using excel.

Duration                 5 Days

Who Should Attend

The course targets Statistician, analyst, or a budding data scientist and beginners who want to learn how to analyse 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.
 Nairobi Aug 12 - 16 Aug, 2024 Nairobi, Kenya 09 - 13 Sep, 2024 Kigali, Rwanda 14 - 18 Oct, 2024 Mombasa, Kenya 11 - 15 Nov, 2024 Nairobi, Kenya 09 - 13 Dec, 2024

Class Session: 08:00:am - 16:00:pm

 USD 2,950.00 (Kigali) USD 4,500.00 (Dubai) USD 1,500.00 (Nairobi) USD 1,500.00 (Mombasa)
(Convert Currency)

DUNCAN KARIUKI +254723360025

DATA-AFRIQUE CONSULTANCY

#### Related Courses

Training Course On Monitoring And Evaluation For Health Programs

5 days, 12 - 16 Aug, 2024

Data-Afrique Consultants

Making informed decisions, improving effectiveness and health programs is achieves in the health sector via the use of proper monitoring and evaluation. M&E ensures the implementation of health ...

Training Course On Impact Evaluation For Evidence Based Development

5 days, 12 - 16 Aug, 2024

Data-Afrique Consultants

Impact evaluation involves the assessment of changes as a result of projects, programs, or policies. This included both the intended and unintended interventions. This course aims at imparting skills ...

GIS and Spatial Analysis For Agriculture and Food Security Training

5 days, 12 - 16 Aug, 2024

Data-Afrique Consultants

Increasing food demands due to high rates of population growth and major changes in political and economic and social systems have created an urgent need to develop new and revise many existing ...

Training Course On Leadership Skills For Financial Managers

5 days, 12 - 16 Aug, 2024

Data-Afrique Consultants

Leadership is a crucial skill for all managers to not only learn but practice. This course covers the topic on leadership skills which entails the development of an environment where all stakeholders ...