Statistics for Data Analysis Using Excel 2016
4.4 (1,537 ratings)
8,922 students enrolled

# Statistics for Data Analysis Using Excel 2016

Plain & Simple Lessons on Descriptive & Inferential Statistics Theory With Excel Examples for Business & Six Sigma
4.4 (1,540 ratings)
8,924 students enrolled
Created by Sandeep Kumar ­
Last updated 7/2020
English
English
Current price: \$93.99 Original price: \$134.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 14.5 hours on-demand video
• 1 article
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

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.
Course content
Expand all 113 lectures 14:24:17
+ 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:13:04
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)
13:15
Preview 08:01
Two Sample t Test (Theory)
08:45
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:20
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
05:46
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 37:52
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)
09:20
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
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