Statistics Made Easy by Example for Analytics/ data science
4.2 (330 ratings)
2,224 students enrolled

# Statistics Made Easy by Example for Analytics/ data science

Statistics Simplified - Statistics Made Easy by Excel Simulations. Master fundamentals of statistics & Probability.
4.2 (330 ratings)
2,224 students enrolled
Last updated 7/2019
English
English
Current price: \$11.99 Original price: \$19.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
• 10.5 hours on-demand video
• 3 articles
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

What you'll learn
• By the end of this course, you should become very comfortable with popular concepts of statistics
• You should know the genesis of popular statistical concepts
• You should know how you apply it in business problem
• You should have the required course material for referral
Course content
Expand all 112 lectures 15:48:15
+ Probability and Expectations
10 lectures 41:17
Preview 03:32
Preview 01:56
Relative Frequency and Probability with Excel simulation
10:14

00:05
Probability Example of rolling one and two dice
06:44
Probability distribution function - descrete and continuous
03:56
Expectation or Expected Value
04:17
Expected Value of a Carnival Game
07:27
Expected value of Casino Game
03:06
Calculate probability, expected value etc.
7 questions
Section PDF
21 pages
+ Central Tendencies and Dispersion
16 lectures 59:08
Preview 02:13
Arithmetic Mean
09:50
Geometric Mean and Its applicability
04:17
Weighted Mean
03:06
Median and Its Calculations
03:26
01:29
05:10
Dispersion: Why you shd Know
02:00
01:57
Average Absolute Difference
04:50
Variance and Standard deviation
06:10
Note: Square Error Is Minimum around Mean
03:01
Coefficient of Variance and Z statistics
06:12
Exercise - caculate central tenedencies, dispersion etc.
01:00
Section PDF
39 pages
+ Central Limit Theorem
8 lectures 52:06
Preview 01:55
Frequency Distribution
04:40
Real Life Example of Normal distribution
09:43
Normal distribution due to aggregation
06:19

Both the files are same. If by chance you are not able to use .xlsm file, please use .xlsx file and save that to .xlsm file as per the instruction given in the worksheet.

CLT concepts and demo
10:13
Exercise - Central limit theorem etc.
5 questions

Check, if you learnt it correctly

Apply the concepts of CLT
1 question
Validate properties of Normal Distribution
06:19
Check properties of Normal Distribution
4 questions
Section PDF
26 pages
+ Sampling Distribution
18 lectures 02:08:41
Preview 02:56
Terms Associated with Sampling Distribution
08:08
Examples of Sample Statistic
01:41
Sampling distribution of Means
12:05
Sampling Distribution of proportion
14:49
Optional topic - Sampling distribution of means and proportions with IID series
08:51
Point Estimate and Interval Estimate
09:20
Intuitive Understanding and Demo of confidence Interval
16:16
Formal defintions and table for confidence interval
08:04
Calculation example of confidence interval for sample proportions
03:32
Confidence Interval for Mean
04:01
Demo of confidence Interval for Mean
09:38
Example of Confidence Interval Calculation
04:52
Preamble for small sample statistic
01:46
Preview 13:37
Confidence Interval Calculation Example for Small Sample
05:16
Criteria of a good Estimator
03:49
Exercise - Check sampling distribution concepts
9 questions
Section PDF
47 pages
+ Hypothesis Testing
14 lectures 02:03:41
Preview 01:55
Business Example of Hypothesis Testing - part 01
14:37
Business Example of Hypothesis Testing - part 02
14:18
Introduction to Terms of Hypothesis Testing
12:42
Steps of Hypothesis Testing
06:42
Type I and II and Power of a test - part 01
14:11
Type I and II and Power of a test - part 02
14:32
One and Tow Tail Tests
07:16
Hypothesis Testing Examples 01
06:34
Hypothesis Testing Examples 02
07:26
Using MS Excel for Hypothesis Tests
05:48
Exercise - Apply your learning of hypothesis testing
10 questions
Section PDF
48 pages
+ Simple Linear Regression
9 lectures 56:55
Preview 02:03
Linear Relationship By Example
05:47
Ordinary Least Square for Equation
10:28
Understand Excel Chart Add Trendline Function
04:34
Coefficient of determination
09:11
Correlation Coefficient R
07:50
Use of Linear Regression
03:49
Exercise - Apply your learning of Linear Regression
12 questions
Section PDF
33 pages
+ Categorical Data Analysis
12 lectures 01:04:19
Preview 01:57
Introduction to Categorical Variable
03:34
Describe Categorical data one way
09:54
Describe Categorical data two way
08:29
Chi Square Statistic
10:53
Degree of freedom of a cross tab
05:44
Chi Square Distribution
05:38
Using Excel to conduct Chi Square Test
05:35
dependent and independent variable
03:23
Exercise - Apply your learning of Categorical data analysis
8 questions
Section PDF
27 pages
+ Analysis of Variance (ANOVA)
12 lectures 45:23
Preview 02:35
Scenario for ANOVA
04:25
Clarity on ANOVA design
04:48
Assumptions of ANOVA
01:10
Preview 06:43
Calculate Between Sample Variance
04:15
Calculate within Sample Variance
02:38
Demo When Null Hypothesis Is True
08:02
Intutive Understanding when samples are from different population
02:32
F Statistics and F Distribution
03:53
Conducting ANOVA using Excel
04:22
Exercise - Apply your learning of ANOVA
9 questions
Section PDF
31 pages
+ Non Parametric Tests
13 lectures 01:12:44
Preview 01:14
Scenario for Non Parametric Test
07:27
Monotony vs Linearity
03:29
03:35
Sign Test
08:31
Mann Whitney U Test
12:04
Kruskal Wallis H Test
09:06
One Sample Run Test
11:16
Preview 07:37
Section PDF
32 pages
Bonus Topic: How to master SAS .or R programming?
00:17
Closure Note
02:09
Requirements
• Familiarity with Microsoft Excel basics
Description

This course promises that students will

• Learn the statistics in a simple and interesting way
• Know the business scenarios, where it is applied
• See the demonstration of important concepts (simulations) in MS Excel
• Practice it in MS Excel to cement the learning
• Get confidence to answer questions on statistics
• Be ready to do more advance course like logistic regression etc.

Course Material

• The course comprises of primarily video lectures.
• All Excel file used in the course are available for download.
• The complete content of the course is available to download in PDF format.

How long the course should take?

It should take approximately 25 hours for good grasp on the subject.

Why take the course

• To understand statistics with ease
• Get crystal clear understanding of applicability
• Understand the subject with the context
• See the simulation before learning the theory
Who this course is for:
• MBA Students
• Statistics professionals
• Statistics students
• Analytics professionals
• Data analytics folks
• IT folks, Reporting Engineers who want to build their career into analytics or statistical analysis / market research