confidence

2 Topics

Find 95% Confidence Interval for Difference of Means
Client has asked for a graph of two columns' distributions to change color if the difference in means is ever statistically significant (or by my understanding, the 95% confidence interval doesn't contain 0). The changing color part is fairly idiomatic to Power BI. The 95% CI for Difference of Means? Not so much. I've got more math background than stats background. If nothing else, I can make one big fat DAX function using the mathematical formula for difference of means Confidence Interval, which is a doozie. That feels like it's pretty computation-heavy, requiring two averages, two standard deviations, a T.INV, and a square root to be done just as the precursors to a final calculation. I'm wondering if there's a more efficient DAX approach to this than just brute-forcing the equation. I looked into CONFIDENCE.T and CONFIDENCE.NORM, which are single-mean tests, and my gut tells me there might be a way to manipulate one of those into working, but I don't have the stats background to know what it would be.
Solved
Nankaina
3 years ago Place DAX Commands and Tips
2.4KViews
0likes
3Comments
Alternative to CONFIDENCE.NORM function (function is missing in Excel 2016)
I have some DAX calculated columns in which I want to use CONFIDENCE.NORM to return the upper and lower bounds of a forecast based on a 95% confidence interval, however it seems that Excel 2016 does not have this function. I am wondering if anyone knows an alternative to this that I can use in Excel 2016. I have attached the workbook below - the problem calculation is in the Facts_Calc table of the Data Model. Forecast Problem
JollyRoger01
5 years ago Place DAX Commands and Tips
1.3KViews
0likes
3Comments