Friday, March 20, 2009

New Excel Trick

Without going into the details, I had to create a spreadsheet that had a group of values distributed throughout, where the same number showed up the same number of times throughout, but not at the same place throughout. I put something together that looked right, but I needed a way to find out how the numbers were distributed in the sheet.

In Excel, go to Tools, then Analysis, and choose the Histogram function. It'll generate a new sheet with the distribution for you. Pretty cool.

No comments: