INTRODUCTION

Data analysis and statistics are the focus of this course. You will learn advanced statistical and data analysis ideas in this course, and it will assist you in putting them into practice. We will utilize a variety of examples and data sets before demonstrating how to make these calculations using Microsoft Excel..

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 is intended for novices who wish to learn how to analyze data using Excel as well as statisticians, analysts, or aspiring data scientists.

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

• Our seasoned instructors, who have years of experience as seasoned professionals in their respective fields of work, will be teaching this course. A combination of practical exercises, theory, group projects, and case studies are used to teach the course.
• The participants receive training manuals and supplementary reading materials.
• Participants who complete this course successfully will receive a certificate.
• We can also create a course specifically for your organization to match your needs. To learn more, get in touch with us at training@dealsontrainers.org.
• The training will take place at DEALSON TRAINERS IN NAIROBI, KENYA in Nairobi, Kenya.
• The training fee includes lunch, course materials, and lodging for the training session. Upon request, we may arrange for our participants' lodging and transportation to the airport.
• Payment must be made to our bank account before the training begins, and documentation of payment should be emailed to training@dealsontrainers.org