Data Analysis, Modeling and Simulation using Excel Course

Data Analysis, Modeling and Simulation using Excel Course

Share this Workshop

Course Date Duration Location Registration
03/04/2023 To 07/04/2023 5 Days Nairobi Kenya
01/05/2023 To 05/05/2023 5 Days Kigali,Rwanda
29/05/2023 To 02/06/2023 5 Days Mombasa, Kenya
26/06/2023 To 30/06/2023 5 Days Nairobi Kenya
07/08/2023 To 11/08/2023 5 Days Nairobi Kenya
14/08/2023 To 18/08/2023 5 Days Nairobi Kenya
21/08/2023 To 25/08/2023 5 Days Mombasa, Kenya
21/08/2023 To 25/08/2023 5 Days Nanyuki, Kenya
04/09/2023 To 08/09/2023 5 Days Nairobi Kenya
18/09/2023 To 22/09/2023 5 Days Naivasha,Kenya
02/10/2023 To 06/10/2023 5 Days Nairobi Kenya
16/10/2023 To 20/10/2023 5 Days Kigali,Rwanda
30/10/2023 To 03/11/2023 5 Days Nairobi Kenya
27/11/2023 To 01/12/2023 5 Days Nairobi Kenya
18/12/2023 To 22/12/2023 5 Days Mombasa, Kenya

 

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 in English

·         Presentations are well-guided, practical exercises, web-based tutorials, and group work. Our facilitators are experts with more than 10 years of experience.

·         Upon completion of training the participant will be issued with a Foscore development center certificate (FDC-K)

·         Training will be done at the Foscore development center (FDC-K) centers. We also offer inhouse and online training on the client schedule

·         Course duration is flexible and the contents can be modified to fit any number of days.

·         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.

·         Accommodation, pickup, freight booking, and Visa processing arrangement, are done on request, at discounted prices.

·         Tablet and Laptops are provided to participants on request as an add-on cost to the training fee.

·         One-year free Consultation and Coaching provided after the course.

·         Register as a group of more than two and enjoy a discount of (10% to 50%)

·         Payment should be done before commence of the training or as agreed by the parties, to the FOSCORE DEVELOPMENT CENTER account, so as to enable us to prepare better for you.

·         For any inquiries reach us at training@fdc-k.org or +254712260031

 

·         Website:www.fdc-k.org

 

Foscore Development Center |Training Courses | Monitoring and Evaluation|Data Analysis|Market Research |M&E Consultancy |ICT Services |Mobile Data Collection | ODK Course | KoboToolBox | GIS and Environment |Agricultural Services |Business Analytics specializing in short courses in GIS, Monitoring and Evaluation (M&E), Data Management, Data Analysis, Research, Social Development, Community Development, Finance Management, Finance Analysis, Humanitarian and Agriculture, Mobile data Collection, Mobile data Collection training, Mobile data Collection training Nairobi, Mobile data Collection training Kenya, ODK, ODK training, ODK training Nairobi, ODK training Kenya, Open Data Kit, Open Data Kit training, Open Data Kit Training, capacity building, consultancy and talent development solutions for individuals and organisations, through our highly customised courses and experienced consultants, in a wide array of disciplines

Other Upcoming Workshops Kenya, Rwanda, Tanzania, Ethiopia and Dubai

1 Grant and Proposal Writing Course
2 Corporate Governance for Board Members & Directors Course
3 Marketing Research and Analysis course
4 Trauma Support and Counselling Course
5 Debt Collection, Recovery, Negotiation, and Credit Control Management
6 Entrepreneurship and Innovation Course
7 Project Management Monitoring and Evaluation with MS Projects Course
8 GIS for Monitoring and Evaluation Course
9 Gis for Disaster Risk Management Course
10 Performance Management for public officers
Chat with our Consultants WhatsApp