Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about the Normal (Bell) Probability Distribution and the Excel worksheet functions to calculate probability and x values: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV.
Topics:
1. (00:00) Introduction
2. (00:22) pdf notes: characteristics of Normal Bell Probability Distribution.
3. (04:40) pdf notes: Math Formulas for Normal (Bell) Probability Distribution
4. (05:14) pdf notes: X values or Z-score (Standard Value)?
5. (05:50) pdf notes: notes on Excel Functions for Normal (Bell) Probability Distribution: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV
6. (08:49) pdf notes: Professor observes a bell shape (normal) distribution.
7. (09:07) pdf notes: 3 Types of Probability Calculations: Below an X or Z, Above an X or Z, or Between two x values or z values.
8. (11:58) Excel example: Learn how Standard Deviation determines the height of a Normal Bell Curve
9. (12:58) Excel example: Learn how Mean determines the position of a Normal Bell Curve on the X or Z horizontal axis
10. (14:41)ABOVE: How to use Excel Functions NORM.DIST, NORM.S.DIST to calculate probability below an X or Z
11. (17:26)BELOW: How to use Excel Functions NORM.DIST, NORM.S.DIST to calculate probability above an X or Z
12. (19:02)BETWEEN: How to use Excel Functions NORM.DIST, NORM.S.DIST to calculate probability between two an X values or Z values
13. (21:28) How to use Excel Functions NORM.INV, NORM.S.INV to calculate an X or Z value from a cumulative probability
14. (23:06) Summary of video
15. (23:28) Next Video, Closing and Video Links