Powerpivots are a great tool for exploring data and drilling down into trends and patterns. However as you drill down into subsets of the data, sample sizes decrease and you need to be cautious as to how you interpret results. 95% confidence intervals are a simple but useful tool to determine if two or more groups or samples of the data are significantly different.
This post demonstrates how to insert dynamic 95% confidence intervals into Powerpivots- this means the 95% confidence intervals automatically update based on the sample size and interval variation within the group.