Applied Statistics using Excel

Course Overview

This course revolves around statistics and data processing using excel. This course is designed to teach you the fundamental principles of statistics and data analysis, and will assist you in the application of these principles. Different examples and data-sets are used to illustrate the application.

At the end of the training, participants will be able to:

  • ● Explain the concept of applied statistics
  •  
  • ● Explain descriptive statistics
  •  
  • ● Discuss probability distribution
  •  
  • ● Describe hypothesis testing
  •  
  • ● Discuss two sample tests
  •  
  • ● Explain linear regression in excel

Pre-requisite

  • Basic knowledge in Microsoft Excel

Duration

2 days

Course Outline

  1. The Role of Statistics
  2. Sample & Population data
  3. Fundamentals of Descriptive Statistics
  1. Descriptive Statistics
  2. Measure of Central Tendency
  3. Measure of Dispersion
  1. Distributions
  2. Skewness and Kurtosis
  1. Central Limit Theorem
  1. Tests for Mean, Variance and Proportions
  1. Simple Linear Regression

Descriptive Statistics

Reviews