One of the most time-saving techniques that I figured out over the past few years is how to integrate paired samples t-tests into my interactive dashboard. Think about it: By including t-tests, my dashboards are basically calculating scores and scores of paired samples t-tests behind the scenes!

​For instance: Say you want to know if females, in particular, showed statistically significant gains? Boom!...Click on the slicers in my interactive dashboard, and you'll get your answer in seconds! What about females who are underrepresented minority students and who are majoring in Physics? Yep...my dashboard will calculate that for you in an instant!

Want to know the steps?  

Once you've created your interactive dashboards in Excel using my famous PARCS method, you will be tempted to share your Excel workbooks with clients and colleagues. You designed something amazing, and it only makes sense that you would want to share it with the world, right?

HOLD ON! 
Aren't you forgetting something???

Do you use traditional pre/post surveys to assess programmatic impact on participants?  If so, you might have encountered the following known problems: