Essential Statistics for Data Analysis using Excel

Course objective

Refresh your understanding of essential statistics needed for data analysis to build a solid foundation for your data analysis career. Statistics and basic probability are essential components to understanding data. In this course, you’ll learn how to use excel to preform descriptive statistics, basic probability, random variables, sampling, confidence intervals, and hypothesis testing. We’ll teach you how Excel can help you analyse data from many industries, including medical, business, sports, insurance, and much more. and basic probability.

What you will learn

In this course, you will learn how to:

  • How to describe data using charts and basic statistical measures
  • Basic probability including the law of complements, independent events, conditional probability, and Bayes Theorem
  • How to find the mean and variance of random variables and then learn about the binomial, Poisson, and normal random variables
  • The mechanics of sampling, point estimation, and interval estimation of population parameters
  • Null and alternative hypotheses

Prerequisites

  • Secondary school algebra
  • Ability to work with tables, formulas, and charts in Excel
  • Ability to organise and summarise data using Excel analytic tools such as tables, pivot tables, and pivot charts

You can meet these prerequisites though our Introduction to Data Analysis using Excel.
Note: Access to Excel 2016 is required for the full course experience.

What is included

  • Videos and reading resources
  • A total of 182 questions
  • Final exam with 30 questions
  • Hands-On Labs
  • Certification
  • Textbook

Course Outline

  1. Descriptive statistics
  2. Basic probability
  3. Random variables
  4. Sampling and confidence intervals
  5. Hypothesis testing