### TRAINING COURSE ON DATA ANALYSIS MODELING AND SIMULATION USING EXCEL

Course Date Location Course fee: Registrations (Group)
Start Date: 19/12/2022 End Date: 23/12/2022 Mombasa \$ 1,000 Register as Individual Register for Online Training Register as a Group
 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: 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 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@data-afriqueconsultancy.org The training will be conducted at DATA-AFRIQUE TRAINING CENTRE, 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@data-afriqueconsultancy.org

### Our 2022 Group Rates (in USD)

# of Days
Group #
5 DAYS PER PERSON
10 DAYS PER PERSON
#
PAXS
USD
USD
1. 1 1000.00 2000.00
2. 2 - 10 800.00 1,600.00
3. 11 - 20 750.00 1,500.00
4. 21 - 30 700.00 1,400.00
5. 32 - 40 650.00 1,300.00
6. 41 - 50 600.00 1,200.00
7. 51 > Above 500.00 1000.00