Categories

2017-08-03 17:51:22

Statistics for Data Analysis Using Excel 2016

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

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

Bestselling

303 students enrolled

Current price: $10
Original price: $145
Discount:
93% off

30-Day Money-Back Guarantee

- 14.5 hours on-demand video
- 51 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.

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

Students Who Viewed This Course Also Viewed

Curriculum For This Course

112 Lectures

14:33:12
+
–

Statistics Introduction and Definitions
2 Lectures
09:36

+
–

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

About the Instructor

Bestselling Udemy Instructor- Six Sigma / ISO 9001 /Quality

*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).

- About Us
- Udemy for Business
- Become an Instructor
- Affiliate
- Blog
- Topics
- Mobile Apps
- Support
- Careers
- Resources

- Copyright © 2017 Udemy, Inc.
- Terms
- Privacy Policy and Cookie Policy
- Intellectual Property