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

# Training on Data Analysis, Modeling and Simulation using Excel

## By: Data-Afrique Consultants

Kenya

27 Jun - 01 Jul, 2022  5 days

### USD 1,000

Venue: MOMBASA, KENYA

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 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 and 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
 MOMBASA, KENYA Jun 27 - 01 Jul, 2022
 USD 1,000.00 USD 2,990.00
(Convert Currency)

DUNCAN KARIUKI +254723360025

#### Related Courses

The livelihoods of the world’s poor rise and fall with the fate of agriculture. Enhancing the ability of smallholders to connect with the knowledge, networks, and institutions necessary to ...

Mobile Data Collection using Ona and Kobo Toolbox Course

5 days, 27 Jun - 01 Jul, 2022

Data-Afrique Consultants

This instructor led training course will be delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group ...

Training on Project Cycle Management (PCM)

5 days, 27 Jun - 01 Jul, 2022

Data-Afrique Consultants

Project Cycle Management PCM is a management tool based on the Log-frame approach which is used in project development. The project cycle enables provision of structures that ensures Stakeholders are ...

Training on SMEs Guarantee and Credit Analysis

5 days, 27 Jun - 01 Jul, 2022

Data-Afrique Consultants

The overall goal of this course is to build analytic skills needed to evaluate the credit standing of small and medium sized enterprises. The training will demonstrate how to combine a qualitative ...