problem.solve.create.share

Problem:

I’m currently prepping a consulting project to instruct a Green Belt level course to an group that doesn’t have the budget for expensive statistical software. While Stats Helper can do most simple analysis, it was lacking a few things: namely making control charts and calculating confidence intervals for standard deviation.

Solve:

So, I spent a bit of time and added features to do Individuals Charts, Xbar Charts, and P Charts. Here’s a screenshot:

I also incorporated the ability to calculate confidence intervals for standard deviations, located in the “Understand a Distribution” worksheet. Below is a screenshot:

Create:

Making the graphs update dynamically was a bit tricky. Fortunately there were a few great websites that helped:

• http://office.microsoft.com/en-us/excel-help/using-named-ranges-to-create-dynamic-charts-in-excel-HA001109801.aspx
• http://www.ozgrid.com/Excel/ChartTips.htm
• http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

Share:

Please check out the download page to get your copy.