/programming/data-analysis/course.php?id=2327485

Statistics for Data Analysis Using Excel 2016 (Udemy.com)

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

4.5
( 303 Reviews )

Created by: Sandeep Kumar

Produced in 2021

icon
What you will 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.

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

icon
Course 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 aboutStatistics 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 factsSix Sigma Green and Black Belt professionals using MS Excel to conduct statistical analysis
Read More product length iconTime: 14.5h

icon
Instructor Details

Sandeep Kumar

PMI-PMP, IRCA Registered Lead Auditor, ASQ - CSSBB, CQA, CQE, CMQ/OE, IIA - CIA
Sandeep Kumar has more than35 years ofQuality Management experience. He has worked as Quality Manager/Director on a number of projects, including Power, Oil and Gas and Infrastructure projects.
In addition, he provides consulting services to implement Lean Six Sigma to improve performance.
His areas of specializations include Quality Assurance, ISO 9001:2015, Lean, Six Sigma, Risk Management, QMS Audits, Supplier Quality Surveillance, Supplier Pre-qualification, Construction Quality, Mechanical Inspection and Quality Training.

Professional Qualifications:

His professional qualification/certifications include:
ASQ-CSSBB, Certified Six Sigma Black Belt

ASQ-CMQ/OE Certified Manager of Quality/Organizational Excellence

PMI-PMPCertified Project Management Professional
IRCA Registered Lead Auditor (QMS-2015)
IIA-CIA Certified Internal Auditor

ASQ-CSSGB, Certified Six Sigma Green Belt
ASQ-CQA Certified Quality Auditor
ASQ-CQE Certified Quality Engineer


Read More

icon
More courses by Sandeep Kumar

Six Sigma White Belt

$11.99

ISO 9001:2015 Transition Training Course

$11.99

Six Sigma Statistics Using Minitab 17

$11.99

QMS Auditor / Lead Auditor Course

$11.99

Quality Management for Business Excellence

$11.99

Certified Six Sigma Yellow Belt Training

$11.99

All courses by Sandeep Kumar

icon
More data analysis courses

Microsoft Power BI - Up & Running With Power BI Desktop

$11.99

Python Data Analysis & Visualization Bootcamp

$11.99

Complete Introduction to Microsoft Power BI [2021 Edition]

$11.99

Data Analysis with Pandas and Python

$11.99

Python for Time Series Data Analysis

$11.99

[Intermediate] Spatial Data Analysis with R, QGIS & More

$11.99

All data analysis courses

icon
Reviews

4.5

303 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete
Reset Filter
Write a Review arrow

By Daria Zieba on 11/14/2020

:)

By Sajitha on 11/7/2020

Statistics is explained in very simple terms.

By Clark S Patricio on 11/7/2020

Ive learn alot thanks Teacher

By Abiola Olagunju on 11/1/2020

THE EXPLANATIONS HAVE BEEN VERY CLEAR, EASY TO FOLLOW AND UNDERSTAND SO FAR

By Kavita Chaddha on 10/25/2020

It is a very useful course for the beginners. I learnt a lot from the course.

By Rene Arsalan on 10/17/2020

informative

By Johnson Adeniyi Omorinoye on 10/12/2020

This is a great course.

By Shiona MacPherson on 9/21/2020

very basic so far, difficult to understand accent

By Hamdani Febrian on 9/16/2020

Just like the name suggest, Mr Sandeep is Quality Guru. He is an expert, but can teach with simple and easy to understand terms. Not many people I know can do that. If you want to know about statistics gradually from beginner to up high skills in statistics using Excel, this is the best one! Needed this for my work, but have no time to take real lesson that usually takes weeks, this is the best options from me. Quick deep understanding at your own pace. Awesome!

By Satnirp Athwal on 9/10/2020

clear explanations and easy to undestand

By Palakpreet Bhullar on 8/26/2020

Very basic and nice

By Rohini Nandan Tripathy on 8/24/2020

Clearly explained

Load More

Statistics for Data Analysis Using Excel 2016
Visit Course Write a Review
  • Video Duration: icon 14.5h
  • Price: 11.99 Track Price 11.99 Track Price
  • Provider: icon Udemy
  • Year: icon 2021
  • Language: icon English
  • Certificate: icon Yes
30-Day Money-Back Guarantee

Udemy Coupon Price Tracker

For any issues or feature requests please email CourseDuck's Co-Founder at michaelk@courseduck.com