Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution
excelisfun excelisfun
1.03M subscribers
47,122 views
350

 Published On Feb 17, 2015

Download files (which file shown at begin of video): https://people.highline.edu/mgirvin/A...
Topics in this video:
1. (00:11) Using Handwritten notes, discuss characteristics of the Normal (Bell) Distribution, how to calculate probabilities using Excel functions and the four situations for calculating probabilities and x or z values.
2. (12:18) Excel Chart Example for family of Normal (Bell) Curves.
3. (15:04) Calculate probability on the low end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values.
4. (17:50) Calculate probability on the high end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values.
5. (19:22) Calculate probability between two values using NORM.DIST function with x values and NORM.S.DIST function with z values.
6. (21:51) Find x values using NORM.INV function function or find z value using NORM.S.INV function

show more

Share/Embed