Data Analysis, Modeling and Simulation using Excel Course

Event website: https://fdc-k.org/trainings/516/Data-Analysis-Modeling-and-Simulation-using-Excel-Course-/Research-and-Data-Analysis/4561
Register as individual: https://fdc-k.org/trainings/register/516/4208/Data-Analysis-Modeling-and-Simulation-using-Excel-Course-/3638/capacity-building-courses
Register online for training:  https://fdc-k.org/online-courses/register/516/4208/Data-Analysis-Modeling-and-Simulation-using-Excel-Course-/3638/capacity-building-courses
Register as a group:  https://fdc-k.org/trainings/group/516/4208/1/Data-Analysis-Modeling-and-Simulation-using-Excel-Course-/3638/capacity-building-courses

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