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 t Distribution. Learn about the Excel worksheet functions T.DIST, T.DIST.2T, T.INV, T.INV.2T
Topics:
1. (00:00) Introduction
2. (00:21) Two Tail Test with t Distribution from point of view of Seattle Used Auto Dealers
3. (02:30) Formulas for calculations from sample data
4. (04:04) Calculate p-value using the T.DIST function or T.DIST.2T function
5. (06:22) Calculate critical value using the T.DIST function or T.INV.2T function
6. (08:40) Summary of video, Closing, Next Video and Video Links