Completed
) Excel formulas for Mean and Standard Deviation. Four formulas.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - Binomial Probability Distributions - BINOM.DIST.RANGE Function & Chart
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) First look at binomial probability math formula.
- 3 ) Requirements for a Binomial Experiment.
- 4 ) Why the Binomial Probability Math Formula works. Look at Samples Points and AND Logical Test and the OR Logical Test. Learn about the reason the math formula is valid.
- 5 ) BINOM.DIST and ) BINOM.DIST.RANGE Excel Built-in Functions.
- 6 ) Meand and Standard Deviation formulas for a Binomial Experiment.
- 7 ) Example with Excel formulas to calculate a Binomial Probability with 1) Sample Point Method, 2) Math Formula Method, 3) BINOM.DIST.RANGE function method.
- 8 ) How to use BINOM.DIST.RANGE function for a single X Probability.
- 9 ) Experiment 1: Sell Insurance Policies in four tries. Full example with requirements, formulas and Excel Chart.
- 10 ) SEQUENCE function and BINOM.DIST.RANGE function to spill the entire Binomial Probability Distribution for a Binomial Experiment.
- 11 ) Plot Binomial Probability Distribution in an Excel Column Chart.
- 12 ) Excel formulas for Mean and Standard Deviation. Four formulas.
- 13 ) Calculating various probabilities with the BINOM.DIST.RANGE function.
- 14 ) Experiment 2: Flight from Oakland to Seattle, where probability of the flight being late = 10%.
- 15 ) Experiment 3: Traffic Across Bridge in next 10 workdays, where probability of the getting stuck in traffic = 15%.
- 16 ) Experiment 4: Students withdrawing from Accounting 202 Class with 35 students enrolled, where the probability of withdrawing is 16%.
- 17 ) Look at How Probability Distribution changes as the Number of Trials Increases and the Probability of Success approaches 0.5
- 18 ) Summary of video
- 19 ) Closing and Video Links
