Home » Blog » Statistics for Data Analysis Using Excel

Statistics for Data Analysis Using Excel

Online Course. Plain & Simple Lessons on Descriptive & Inferential Statistics Theory With Excel Examples for Business & Six Sigma

What you’ll learn?

  • You will learn Descriptive and Inferential Statistics with the help of simple but practical examples.
  • You will learn to use the power of Microsoft Excel to perform statistical calculations for you. No need to remember long formulas and equations.
  • You will understand statistics from basic to advance level to solve business problems using Microsoft Excel.
  • You will learn to make sense out of vast amount of data around you, to make fact based decisions.

Requirements

  • You should have some basic understanding of Microsoft Excel.

Description

Start loving data and making sense of it. Leverage the power of MS Excel to make it easy!

Learn statistics, and apply these concepts in your work place using Microsoft Excel.

This course is about Statistics and Data Analysis. The course will teach you the basic concepts related to Statistics and Data Analysis, and help you in applying these concept. Various examples and data-sets are used to explain the application.

I will explain the basic theory first, and then I will show you how to use Microsoft Excel to perform these calculations.

Following areas of statistics are covered:

Descriptive Statistics – Mean, Mode, Median, Quartile, Range, Inter Quartile Range, Standard Deviation

Data Visualization – 3 commonly used charts: Histogram, Box and Whisker Plot and Scatter Plot

Probability – Basic Concepts, Permutations, Combinations

Population and Sampling

Probability Distributions – Normal, Binomial and Poisson Distributions

Hypothesis Testing – One Sample and Two Samples – z Test, t Test, p Test, F Test, Chi Square Test

ANOVA – Perform Analysis of Variance (ANOVA) step by step doing manual calculation and by MS Excel.

Who this course is for:
  • Business managers and data analysts who are trying make decision based on data and facts
  • Six Sigma Green and Black Belt professionals using MS Excel to conduct statistical analysis

See more Statistics courses here

See also...

Budgeting and Scheduling Projects Online Course for health economists

Budgeting and Scheduling Projects

Online Course. Do you want to progress your career? Continue learning new. Earn a certificate ... Read more

Fundamentals of Machine Learning for Healthcare online course for health economists

Fundamentals of Machine Learning for Healthcare

Online Course. This course will introduce the fundamental concepts and principles of machine learning as ... Read more

Presentation training for a health economist

Improve Your Presentation Skills

Online Course. Improve your public speaking skills by using proven branding techniques to make your ... Read more

Pivot Tables, Power Pivot Tables, Power Query & Power BI online course for health economists

Pivot Tables, Power Pivot Tables, Power Query & Power BI

Online Course. 5 Course Excel Bundle: Microsoft Excel, Pivot Tables, Power Pivot Tables, Power Query ... Read more

Introduction to Stata - Hands on! Online Course for Health Economists

Introduction to Stata – Hands-on!

Online Course. All you need to know to start using Stata to analyze your data. ... Read more

Online course: R Programming

R Programming

Online Course. R programming online course by the Johns Hopkins University. In this course, you ... Read more

Categories

Tags