excelisfun | Excel Statistical Analysis 47: Hypothesis Testing with T 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 1 Tail Lower (Left) Hypothesis Test with t Distribution. Learn about the Excel worksheet functions T.DIST and T.INV
Topics:
1. (00:00) Introduction
2. (00:24) 1 Tail Lower (Left) Test with t Distribution from point of view of a Construction company that wants to decide if a new building technique is faster than an older technique
3. (02:46) Formulas for calculations from sample data
4. (04:20) Calculate p-value using the T.DIST function
5. (05:04) Calculate critical value using the T.INV function
6. (07:28 Closing, Next Video and Video Links