Download Excel File: https://excelisfun.net/files/Ch08-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch08-ESA.pdf
Learn about how to create Confidence Interval to estimate a population Mean when Sigma (Population Standard Deviation) is known using the z Distribution and the Excel worksheet functions: NORM.INV, NORM.S.INV and NORM.CONFIDENCE.
Topics:
1. (00:00) Introduction
2. (00:22) Build Confidence Interval when Sigma is Known using the z Distribution
3. (02:59) Method #1 using: NORM.INV function
4. (04:15) Method #2 using: NORM.S.INV function
5. (05:27) Method #3 using: NORM.CONFIDENCE function
6. (06:20) Reasonable Statements that can be made when construction Confidence Intevals
7. (07:37) Be careful because Confidence Intervals do not always contain population parameter
8. (08:23) Summary of video
9. (08:40) Closing, Next Video and Video Links