Statistics Made Easy by Example for Analytics/ data science
4.1 (113 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.
1,088 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Statistics Made Easy by Example for Analytics/ data science to your Wishlist.

Add to Wishlist

Statistics Made Easy by Example for Analytics/ data science

Statistics Simplified - Statistics Made Easy by Excel Simulations. Master fundamentals of statistics & Probability.
4.1 (113 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.
1,088 students enrolled
Last updated 6/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 10.5 hours on-demand video
  • 15 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Familiarity with Microsoft Excel basics
  • Students should be able to check formula used in excel after downloading
Description

What is the course about?

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 is the target audience?
  • 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
Compare to Other Statistics Courses
Curriculum For This Course
111 Lectures
15:46:32
+
Probability and Expectations
10 Lectures 43:51


Relative Frequency and Probability with Excel simulation
10:14

Download Excel files?
02:39

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

Arithmetic Mean
09:50


Geometric Mean and Its applicability
04:17

Weighted Mean
03:06

Median and Its Calculations
03:26

Advantage and Applicability of Median
01:29

Mode Its Advantage and Usage
05:10

Dispersion: Why you shd Know
02:00

Range and Its Advantage and Disadvantage
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

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

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


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

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

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

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

Scenario for ANOVA
04:25

Clarity on ANOVA design
04:48

Assumptions of ANOVA
01:10


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
12 Lectures 01:06:28

Scenario for Non Parametric Test
07:27

Monotony vs Linearity
03:29

Advantage n Disadvantage of Non Parametric Method
03:35

Sign Test
08:31

Mann Whitney U Test
12:04

Kruskal Wallis H Test
09:06

One Sample Run Test
11:16


Section PDF
32 pages

Closure Note
02:09

How to download excel files?
2 pages
About the Instructor
Gopal Prasad Malakar
4.3 Average rating
1,815 Reviews
22,379 Students
16 Courses
Credit Card Analytics Professional- Trains Machine Learning

I am a seasoned Analytics professional with 16+ years of professional experience. I have industry experience of impactful and actionable analytics. I am a keen trainer, who believes that training is all about making users understand the concepts. If students remain confused after the training, the training is useless. I ensure that after my training, students (or partcipants) are crystal clear on how to use the learning in their business scenarios. My expertise is in Credit Card Business, Scoring (econometrics based model development), score management, loss forecasting and MS access based database application development.