Tuesday, May 14, 2013

Excel tip: enable Analysis Toolpak for easy Excel histograms

After performance testing a WCF service, I got a bunch of execution times for which I wanted to create a histogram. That would of course give me a distribution of the execution times, so I could get an idea of how the service typically performs.
I hadn't found an elegant way of doing this - until I bumped into this feature of Excel, which is hidden by default. It's called Analysis Toolpak and it enables a bunch of statistical analysis do be done very quickly.

Check it out here.

No comments:

Post a Comment