Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test HD

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