Probability and Expectations
- Welcome Note
- Section Overview
- Relative Frequency and Probability with Excel simulation
- How to download excel files etc.
- Probability Example of rolling one and two dice
- Probability distribution function - descrete and continuous
- Expectation or Expected Value
- Expected Value of a Carnival Game
- Expected value of Casino Game
- Calculate probability, expected value etc.
- Section PDF
Central Tendencies and Dispersion
- Section Overview
- Arithmetic Mean
- Advantage n Disadvantage of Arithmatic Mean
- Geometric Mean and Its applicability
- Weighted Mean
- Median and Its Calculations
- Advantage and Applicability of Median
- Mode Its Advantage and Usage
- Dispersion: Why you shd Know
- Range and Its Advantage and Disadvantage
- Average Absolute Difference
- Variance and Standard deviation
- Note: Square Error Is Minimum around Mean
- Coefficient of Variance and Z statistics
- Exercise - caculate central tenedencies, dispersion etc.
- Section PDF
Central Limit Theorem
- Section outline
- Frequency Distribution
- Normal Distribution and its properties
- Real Life Example of Normal distribution
- Normal distribution due to aggregation
- CLT concepts and demo
- Exercise - Central limit theorem etc.
- Apply the concepts of CLT
- Validate properties of Normal Distribution
- Check properties of Normal Distribution
- Section PDF
Sampling Distribution
- Section outline
- Terms Associated with Sampling Distribution
- Examples of Sample Statistic
- Sampling distribution of Means
- Sampling Distribution of proportion
- Optional topic - Sampling distribution of means and proportions with IID series
- Point Estimate and Interval Estimate
- Intuitive Understanding and Demo of confidence Interval
- Formal defintions and table for confidence interval
- Calculation example of confidence interval for sample proportions
- Confidence Interval for Mean
- Demo of confidence Interval for Mean
- Example of Confidence Interval Calculation
- Preamble for small sample statistic
- Demo of T Distribution
- Confidence Interval Calculation Example for Small Sample
- Criteria of a good Estimator
- Exercise - Check sampling distribution concepts
- Section PDF
Hypothesis Testing
- Section Outline
- Business Example of Hypothesis Testing - part 01
- Business Example of Hypothesis Testing - part 02
- Introduction to Terms of Hypothesis Testing
- Steps of Hypothesis Testing
- Type I and II and Power of a test - part 01
- Type I and II and Power of a test - part 02
- Real Life Example of Type I and II error
- One and Tow Tail Tests
- P Value for I and II Tail Cases and Excel Computation
- Hypothesis Testing Examples 01
- Hypothesis Testing Examples 02
- Using MS Excel for Hypothesis Tests
- Exercise - Apply your learning of hypothesis testing
- Section PDF
Simple Linear Regression
- Section Outline
- Linear Relationship By Example
- Ordinary Least Square for Equation
- Understand Excel Chart Add Trendline Function
- Coefficient of determination
- Correlation Coefficient R
- Use of Linear Regression
- Linear Regression Using MS Excel Data Analysis Procedure
- Exercise - Apply your learning of Linear Regression
- Section PDF
Categorical Data Analysis
- Section Overview
- Introduction to Categorical Variable
- Describe Categorical data one way
- Describe Categorical data two way
- Chi Square Statistic
- Feel The Chi Square Statistic
- Degree of freedom of a cross tab
- Chi Square Distribution
- Using Excel to conduct Chi Square Test
- dependent and independent variable
- statistical technique applicability at a glance
