Data Analysis, Modeling and Simulation using Excel Course
ENDED
Training by
Foscore Development Center (FDC-K)
Inquire Now
On-Site
/ Training
USD 1,000.00
Details
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
Reviews
Be the first to write a review about this course.
Write a Review
Foscore Development Center(FDC-K) is a global training and consulting firm that has been serving leading businesses in many countries. We specialise in capacity building and talent development solutions for individuals and organisations, through our highly customised courses and experienced consultants, in a wide array of disciplines.