Statistics for Management (MBA) - Foundation of Analytics

Statistics by Example - Statistics Made Easy by Excel Simulations. Master fundamentals of statistics & Probability.
4.3 (40 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.
521 students enrolled
$20
Take This Course
  • Lectures 109
  • Contents Video: 10.5 hours
    Other: 5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2014 English

Course 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

What are the requirements?

  • Familiarity with Microsoft Excel basics
  • Students should be able to check formula used in excel after downloading

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Probability and Expectations
Welcome Note
Preview
03:32
Section Overview
Preview
01:56
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
Section PDF
21 pages
Section 2: Central Tendencies and Dispersion
Section Overview
Preview
02:13
Arithmetic Mean
09:50
Advantage n Disadvantage of Arithmatic Mean
Preview
04:27
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
Section PDF
39 pages
Section 3: Central Limit Theorem
Section outline
Preview
01:55
Frequency Distribution
04:40
Normal Distribution and its properties
Preview
12:57
Real Life Example of Normal distribution
09:43
Normal distribution due to aggregation
06:19
10:13

The file S03_06_CLT_Example is actually an xlsm file (excel macro enabled). I will recommend after you download, change the file extension from xlsx to xlsm. For changing file extension, one should see full file name along with extension, click on rename and then change the extension only.

1 question

Check, if you learnt it correctly

Validate properties of Normal Distribution
06:19
Check properties of Normal Distribution
4 questions
Section PDF
26 pages
Section 4: Sampling Distribution
Section outline
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
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
Demo of T Distribution
Preview
13:37
Confidence Interval Calculation Example for Small Sample
05:16
Criteria of a good Estimator
03:49
Section PDF
47 pages
Section 5: Hypothesis Testing
Section Outline
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
Real Life Example of Type I and II error
Preview
07:08
One and Tow Tail Tests
07:16
P Value for I and II Tail Cases and Excel Computation
Preview
10:32
Hypothesis Testing Examples 01
06:34
Hypothesis Testing Examples 02
07:26
Using MS Excel for Hypothesis Tests
05:48
Section PDF
48 pages
Section 6: Simple Linear Regression
Section Outline
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
Linear Regression Using MS Excel Data Analysis Procedure
Preview
13:13
Section PDF
33 pages
Section 7: Categorical Data Analysis
Section Overview
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
Feel The Chi Square Statistic
Preview
07:15
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
statistical technique applicability at a glance
Preview
01:57
Section PDF
27 pages
Section 8: Analysis of Variance (ANOVA)
Section Overview
Preview
02:35
Scenario for ANOVA
04:25
Clarity on ANOVA design
04:48
Assumptions of ANOVA
01:10
ANOVA Method at a Glance
Preview
06:43

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Gopal Prasad Malakar, Credit Card Analytics Professional - Trains on Data Mining

I am a seasoned Analytics professional with 15+ 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.

Ready to start learning?
Take This Course