Mastering Statistics with Excel

Provided by

  • Duration 20 Hours
  • Price £39 + VAT

Enquire about this course

About the course

Description

This online training course is comprehensive and designed to cover the topics listed under the curriculum.

COURSE CURRICULUM

MODULE 01

  • Working with Excel Functions
  • Understanding Data Types

MODULE 02

  • What is Probability?
  • What is Central Tendency?
  • Variance and Standard Deviation

MODULE 03

  • What is a distribution?
  • Introduction to Normal Distributions
  • Introduction to Sampling Distributions
  • Concept of Estimation
  • Basic Logic of Hypothesis Testing

MODULE 014

  • How the Central Limit Theorem Works
  • Hypothesis Tests with Chi-Square
  • Z and T tests (Independent Samples)
  • Concept of Matched Samples

MODULE 05

  • F-Test for two sample variances
  • Hypothesis Tests Regarding more than two Parameters
  • Types of post-ANOVA testing
  • Repeated Measures ANOVA
  • How to test Hypothesis with two Factors

MODULE 06

  • Multiple Linear Regression
  • What is correlation?

Method of Assessment:

At the end of the course learners will also take an online multiple-choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certification:

Upon successful completion of this course learners will be awarded a Certificate in Mastering Statistics with Excel.

Who is this course for?

This course would be helpful to many different individuals, including those who work in: business, science, data analysis, risk-management or research.

Requirements

Learners must be 16 or over and should have a basic grasp of English, ICT, literacy and numeracy.

Career path

This course would help you become:

  • Actuary
  • Data Analyst
  • Data Scientist
  • Marketing Analyst
  • Researcher
  • Risk Manager

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.