excelisfun | Excel Statistical Analysis 41: Confidence Interval for t Distribution, use when Sigma NOT Known @excelisfun | Uploaded 2 years ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/Ch08-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch08-ESA.pdf
Learn about how to create Confidence Interval to estimate a population Mean when Sigma (Population Standard Deviation) is NOT Known using the t Distribution and the Excel worksheet functions: T.INV, CONFIDENCE.T and also the Data Analysis tool.
Topics:
1. (00:00) Introduction
2. (00:27) t Distributions: Characteristics
3. (04:20) t Distribution Confidence Interval Formula
4. (04:48) Excel T Functions
5. (05:26) How t Curve changes as the Sample Size, n, changes
6. (06:34) Printer Cartridge Example With formulas to calculate sample statistics
7. (08:55) Method #1: T.INV function
8. (09:54) Method #2: CONFIDENCE.T function
9. (11:15) Method #3: Data Analysis Descriptive Statistics Feature
10. (14:27) Restaurant Rating Example, All Three Methods Demonstrated
11. (18:10) Summary of video
12. (18:28) Closing, Next Video and Video Links