Excel 2010 Videos: Courtesy of Slaying Excel Dragons (Michael Girvin, Highland CC)

PROBABILITY VIDEOS


Basic Probability Rules & Functions

#35 Probability Basics (Written Notes)

#36 Probability Basics With Excel  

#37 Probability Laws - Adding, Multiplying & More (Handwritten Notes)

#38 Probability Laws In Excel - Adding, Multiplying & More

#39 HYPGEOM.DIST and Conditional Probabilities 

#40 Joint Probability (Two-Way) Table & More

#41 Joint Probability Table With PivotTable

#42 Bayes Theorem Posterior Probabilities & SUMPRODUCT

#43 Further Explanation of Bayes' Theorem & Posterior Probabilties


Discrete Probability Distributions

#44 Discrete Probabilty Distributions Basics (Hand Written Notes)

#45 Build Discrete Probability Distribution

#46 Discrete Probability Chart With Two Data Sets

#47 Discrete Probability Mean & Standard Deviation

#48 Accounting & Finance Examples of Expected Value & Standard Deviation

#49 Binomial Experiment, Probabilities, Chart & BINOM.DIST Function 


Normal Distributions

#54 Continuous Probability Distributions (Hand Written Notes)

#56 Normal (Bell) & Standard Normal Characteristic (Hand Written Notes)

#57 NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV Functions Bell Curve

#58 Charting Normal Bell Curve in Excel With X and Z Values  & Dynamic Ranges

#59 Normal Bell Probabilities Above X and Area Charts To Show Area Above X

#60 Normal Bell Probabilities Between 2x or Z Values Area Charts & Functions

#61 Find X Given Normal Probabilties NORM.INV & NORM.S.INV Functions

#62 Calculating Bell Normal Distribution Probabilities & X Values 10 Examples


Sampling Distributions

#65 Sample Mean Xbar and Probability, Not X Values

#66 Simple Random Sample Using RAND Function, Sort and Copy Paste

#67 Formula To Extract A Simple Random Sample

#68 Construct Sampling Distribution of Sample Means (Xbar)

#69 Probability That Sample Mean Occur With Given Margin of Error (3 Examples)

#70 Standard Error & Correction Factor For Finite Populations

#71 Sampling Distribution of Xbar As Sample Size Increase Probability Increase

#72 Sampling Distribution of Sample Proportion


Uniform, Binomial, Poissen, and Exponential Probability Distributions 

#50 BINOM.DIST Function (3 Examples) Mean & Standard Deviation for BD

#51 How Shape of Binomial Distribution Changes as n and p Change?

#52 Cumulative BINOM.DIST Chart with IF Function

#53 POISSEN.DIST function Poissen Probability Distribution

#55 Uniform Probability Distributions

#63 Exponential Probability EXPON.DIST Function

#64 Relationship Between Poissen & Exponential Probablility Distributions


Click on the cluster to view links organized into content clusters, EXCEL SKILLSDATA ANALYSISPROBABILITY, & INFERENCE.   



© Andrew Nelson 2012