Download File:
Start File: https://excelisfun.net/files/EMT1432Start.xlsx
Finished File: https://excelisfun.net/files/EMT1432Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/
See how to create nine DAX Formulas that build a Confidence Interval:
1. (00:13) Introduction to the Confidence Interval example, reference video about Statistics, and introduction to Data Model used in this video
2. (03:34) Formula 1: Average Number Printed Pages. See the DAX functions AVERAGE & ROUND
3. (04:41) Formula 2: Sample Size. See the DAX function COUNTROWS.
4. (06:29) Formula 3: Alpha. See the DAX function VALUES.
5. (07:51) Formula 4: Standard Deviation Number Printed Pages. See the DAX functions: STDEV.S & ROUND.
6. (09:35) Formula 5: Margin of Error. See the DAX functions: CONFIDENCE.T & ROUND
7. (12:23) Formula 6: Upper Limit for CI.
8. (12:53) Formula 7: Lower Limit for CI.
9. (13:10) Formula 8: Ad Claim 01. See the DAX functions: FORMAT & VALUES
10. (16:12) Formula 9: Ad Claim 02.
11. (17:05) Add IF & HASONEVALUE DAX Functions to each formula to hide formula in Grand Total Row.
12. (18:57) Summary