Excel Magic Trick 1432: 9 DAX Formulas to Build Confidence Intervals CONFIDENCE.T, STDEV.S…

Download File:
Start File: excelisfun.net...
Finished File: excelisfun.net...
Entire page with all Excel Files for All Videos: 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

[@fredericosequeira947]

Sir, you are a master!! Always watch your videos. Learned more from you than anything else i searched for regarding excel. Fantastic work!! Greetings from Portugal.

[@excelisfun]

You are welcome! Thanks for your support : )

[@RobMichaels1]

I just finished "Microsoft: DAT222x Essential Statistics for Data Analysis using Excel" ( EdX) and thought I learned everything about stats in Excel. But leave it to ExcelIsFun to show us something new ! Thanks Mike !

[@excelisfun]

You are welcome! Yes, Stats are Fun, or maybe: Stats is Fun!!!!

[@excelisfun]

BTW: Everything about stats in Excel!?!?!? There are just 1000s of Statistics things built into Excel. Confidence Intervals (and Hypothesis Testing) are basic topics I teach in my Business Statistics Class. What topics did your Data Analysis Class cover?

[@RobMichaels1]

The class was taught by Wayne Winston and covered topics and used exercises from his book "Microsoft Excel 2016 Data Analysis and Business Modeling" (chapters 41-43, 52, 66-70) and some supplemental material on sampling, CI's and hypothesis testing.

[@excelisfun]

Oh!!! That sounds awesome!!! Probably same topics I teach in my class : )

[@hosseinhosseinpoor9561]

خیلی عالی

[@sonjaleverty]

I know this question does not relate to this video, but I have been watching a ton of your videos. I have a question about conditional formatting. Is there a way I can contact you?

[@agungwangsa7453]

Hi..why can't I find the Confindence.T DAX in Excel 2016? Thank you..

[@Barhomopolis]

Thanks for the awesome video, Mike! Hey, what if I wanna create an all text measure? I'm not joining numbers from my data with a hardcoded text string, but rather joining text strings from the data itself. The fields in my : table are text fields. Tried: Location:=VALUES(LocationsMasterData[Subsidiary/FormerName])&"("&VALUES(LocationsMasterData[PrimaryCustomer])&")" Didn't work. Gave a semantic error that the value of that column in that table could not be determined in the current context. Any ideas?

[@excelisfun]

Maybe the CONCATENATEX Function?

[@Barhomopolis]

Mmmm... Maybe, but I'll never know coz I don't have it. My company is on Office 2013 still! =/ But thanks, Mike.