Statistics for Data Analysis Using Excel 2016
4.4 (49 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
615 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Statistics for Data Analysis Using Excel 2016 to your Wishlist.

Add to Wishlist

Statistics for Data Analysis Using Excel 2016

Plain & Simple Lessons on Descriptive & Inferential Statistics Theory With Excel Examples for Business & Six Sigma
Best Seller
4.4 (49 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
615 students enrolled
Created by Sandeep Kumar ­
Last updated 8/2017
English
Current price: $10 Original price: $145 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 14.5 hours on-demand video
  • 1 Article
  • 52 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • 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
Compare to Other Data Analysis Courses
Curriculum For This Course
113 Lectures
14:33:14
+
Statistics Introduction and Definitions
2 Lectures 09:36

Statistics Defined
04:59
+
Basics of Statistics and Microsoft Excel
12 Lectures 01:42:59
Section Introduction - Basics of Statistics and Excel
01:40

Excel Interface (Excel)
06:28

Types of Data in Excel - Text, Numbers, Date/Time, Logical (Excel)
08:45

Qualitative vs Quantitative Data / Continuous vs Discrete (Theory)
04:37

Measurement Scales - Nominal, Ordinal, Interval & Ratio (Theory)
12:04

Basic Statistical Terms - Population and Sample (Theory)
06:39

Understanding Data Types in mtcars Dataset (Excel)
07:58

Understanding Formulas and Functions (Excel)
05:12

Applying Formula to Convert Car Weights from lb to kg (Excel)
05:17

Relative vs Absolute Reference (Excel)
06:05

Basic Formulas, Functions and Named Ranges (Excel)
14:44

More Functions (Excel)
23:30

Practice Activity - Basics of Statistics and Excel - Quiz 1
5 questions
+
Descriptive Statistics
9 Lectures 01:24:32

Descriptive Statistics (Theory)
04:29

Descriptive Statistics - Central Tendency (Theory)
12:14

Descriptive Statistics - Variation (Theory)
11:36

Installing Data Analysis Pack and Calculating Descriptive Statistics (Excel)
07:51

Descriptive Statistics - Central Tendency (Excel)
10:17

Descriptive Statistics - Variation (Excel)
07:02

Descriptive Statistics - Shapes (Theory and Excel)
11:55

Arrays (Excel)
17:21

Practice Activity - Descriptive Statistics - Quiz 2
7 questions
+
Data Visualization
8 Lectures 39:06

Histogram (Theory)
04:04

Create Histogram (Excel)
07:58

Histogram Shapes (Theory)
06:28



Scatter Diagram (Theory)
03:29

Create Scatter Plot using Excel
08:01

Practice Activity - Data Visualization - Quiz 3
5 questions
+
Basic Probability Concepts
6 Lectures 57:28

Basic Probability Concepts - Part 1 (Theory)
07:48

Basic Probability Concepts - Part 2 (Theory)
09:36

Basic Probability Concepts - Part 3 (Theory)
16:18

Basic Probability Concepts - Part 4 (Theory)
06:25

Calculate Factorial, Permutations and Combinations (Excel)
15:47

Practice Activity - Basic Probability Concepts - Quiz 4
4 questions
+
Probability Distributions
12 Lectures 02:19:01

Central Limit Theorem (Theory)
14:59

Central Limit Theorem Demonstration (Excel)
13:55

Normal Probability Distribution (Theory)
19:35

Normal Probability Distribution (Excel)
15:01

Binomial Probability Distribution (Theory)
16:19

Binomial Probability Distribution (Excel) - 1
12:45

Binomial Probability Distribution (Excel) - 2
06:47

Other Distributions Related to Binomial Distribution (Theory)
12:18

Other Distributions Related to Binomial Distribution (Excel)
11:10

Poisson Distribution (Theory)
06:16

Poisson Distribution (Excel)
07:54

Practice Activity - Probability Distributions - Quiz 5
6 questions
+
Hypothesis Testing
35 Lectures 04:17:10

Hypothesis Testing - Types of Errors
15:39

Hypothesis Testing Explained
13:06

Tests for Mean, Variance and Proportions - Introduction
04:47

One Sample z Test (Theory)
07:07

One Sample z Test - Introduction (Excel)
09:06

One Sample z Test - Two Tail Example (Excel)
05:44

One Sample z Test - One Tail Example (Excel)
07:50

Understanding the p Value (Theory)
04:10

One Sample t Test (Theory)
06:18

One Sample t Test - Introduction to T Functions (Excel)
13:54

One Sample t Test - Example (Excel)
05:49

One Sample p Test (Theory)
08:03

One Sample p Test (Excel)
07:58

Two Sample z Test (Theory)
16:54


Two Sample t Test (Theory)
08:44

Two Sample t Test - Equal Variance (Theory)
13:47

Two Sample t Test - Equal Variance (Excel)
04:32

Two Sample t Test - Unequal Variance (Theory)
05:38

Two Sample t Test - Unequal Variance (Excel)
04:08

Two Sample t Test - Paired t Test (Theory)
08:19


Two Sample p Test - Introduction (Theory)
06:17

Two Sample p Test - Example (Excel)
03:44

Tests for Variance (F and Chi Square) - Introduction
05:22

F Test to Compare Variances
11:03

Plotting F Distribution in Excel
05:38

F Distribution Related Functions in Excel
06:44

F.TEST Function in Excel
04:54

F Test Using Data Aanalysis Pack
03:46

Chi Square Test for Variance
06:15

Plotting Chi Square Distribution in Excel
05:57

Chi Square Distribution Related Functions in Excel
05:55

Chi Square Test Example using Excel
03:42

Practice Activity - Hypothesis Testing - Quiz 6
6 questions
+
ANOVA - Analysis of Variance
8 Lectures 01:05:03

Why do you need ANOVA?
09:02

Understanding the concept behind ANOVA without doing any calculation.
11:29

Formulas and calculations in ANOVA
05:12

Performing ANOVA with manual calculations
14:46

Performing ANOVA using Microsoft Excel
03:39

Two Factor ANOVA without Replication (Excel)
08:18

Two Factor ANOVA with Replication (Excel)
09:25

Practice Activity - ANOVA - Quiz 7
2 questions
+
Goodness of Fit and Contingency Table
5 Lectures 42:43
Section Introduction - Goodness of Fit and Contingency Tables
00:50

Goodness of Fit Test (Theory)
10:56

Goodness of Fit Test (Excel))
06:52

Contingency Table (Theory)
14:11

Contingency Table (Excel)
09:54
+
Correlation and Linear Regression
15 Lectures 01:15:34
Section Introduction - Correlation and Regression
03:19

Introduction to Correlation
04:12

Correlation Coefficient - Manual Calculation
06:32

Plotting Scatter Plot and Calculating Correlation Coefficient (Excel)
04:12

Correlation Coefficient for Mutliple Variables (Excel)
08:08

Correlation Related Functions (Excel)
04:13

Correlation Coefficient - Summary
05:08

Correlation vs Causation
03:32

Coefficient of Determination
02:47

Regression Equation - Manual Calculation
10:30

Regression Related Functions - Slope, Intercept (Excel)
04:04

Regression Related Functions - Forecast.Linear (Excel)
04:17

Regression Related Functions - Trend (Excel)
05:09

Regression Related Functions - Linest (Excel)
02:59

Regression using Data Analysis Pack (Excel)
06:32
1 More Section
About the Instructor
Sandeep Kumar ­
4.4 Average rating
4,421 Reviews
23,537 Students
11 Courses
Best Selling Udemy Instructor- Six Sigma/ISO 9001/Statistics

PMI-PMP, IRCA Registered Lead Auditor, ASQ - CSSBB, CQA, CQE, CMQ/OE, IIA - CIA

Sandeep Kumar has around 30 years of Project Quality Management (Engineering, Procurement and Construction) experience in power, oil/ gas, and mining industry. He has worked as Quality Manager on a number of projects including Power, Oil and Gas and Infrastructure projects.

Currently, he is working as Project Quality Director on multiple projects in Alberta, Canada.

His areas of specializations include Quality Assurance, ISO 9001:2008, ISO 9001:2015, Six Sigma, QMS Audits, Supplier Quality Surveillance, Supplier Pre-qualification, Construction Quality, Welding, NDT, Mechanical Inspection and Quality Training.

He has authored and presented a number of Quality Management courses for organizations he has worked for.

Professional Qualifications:

His professional qualification/certifications include: IRCA registered Lead Auditor (QMS), ASQ-CSSBB, Certified Six Sigma Black Belt (CSSBB), ASQ-CSSGB, Certified Six Sigma Black Belt (CSSBB), ASQ-Certified Quality Auditor (CQA), ASQ-Certified Quality Engineer (CQE) and ASQ-Certified Manager of Quality/Organizational Excellence (CMQ/OE), Certified Project Management Professional (PMP) and Certified Internal Auditor - IIA (CIA).