excelisfun | Excel Statistical Analysis 44: Hypothesis Testing with Z Distribution, 1 Tail Lower (Left) Test @excelisfun | Uploaded 2 years ago | Updated 1 day 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 One Tail Hypothesis Test to the Left with z Distribution. Learn about the Excel worksheet functions NORM.S.DIST and NORM.S.INV.
Topics:
1. (00:00) Introduction
2. (00:26) One Tail Test to the Left (Lower Test) with z Distribution from point of view of consumer group concerned with product consistency
3. (07:17) Calculate p-value using the NORM.S.DIST function
4. (08:50) Calculate critical value using the NORM.S.INV function
5. (10:36) Summary of video
6. (19:46) Closing, Next Video and Video Links