excelisfun | Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test Example @excelisfun | Uploaded 2 years ago | Updated 8 hours ago
Download Excel File: https://excelisfun.net/files/Ch09-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch09-ESA.pdf, https://excelisfun.net/files/Ch09-ESA-JustFormulas.pdf
Learn about Two Tail Hypothesis Test with z Distribution. Learn about the Excel worksheet functions NORM.S.DIST and NORM.S.INV

Topics:
1. (00:00) Introduction
2. (00:22) Two Tail Test with z Distribution from point of view of a manufacturer concerned with filling machine accuracy
3. (05:17) Calculate p-value using the NORM.S.DIST function
4. (07:39) Calculate critical value using the NORM.S.INV function
5. (09:31) Summary of video
6. (09:43) Closing, Next Video and Video Links