In Dating Site Photo Effectiveness I proposed dot plots to show how different topics of profile pictures lead to different success rates of attracting attention from potential dates. The original analysis in The 4 Big Myths of Profile Pictures used bar charts which were potentially confusing because the origin of the bars was not zero, [...]

In Preliminary Data Exploration in Excel I showed how to start the process of analyzing a table of data. The data I started with was a flat table, one row per observation, but it wasn’t normalized. That is, each input parameter had its own field. A more flexible arrangement is to replace the several fields [...]

A few well-designed charts, based on carefully manipulated data, can bring a lot of understanding to a set of data. This is an example taken from a manufacturing facility; the data has been obfuscated to protect any trade secrets, but then, I’ve been out of manufacturing for over five years. The data consists of 71 [...]

Yesterday we were treated to discussions about the visitor stats of several Excel bloggers: Chandoo: June was Pointy Haired Dilbert Blog’s Best month ever J-Walk’s Spreadsheet Page Blog: June Visitor Stats Daily Dose of Excel’s June Stats Peltier Tech Blog’s Web Stats – June 2009 Debra’s Contextures 200906 Site Stats I thought it would be [...]

Chandoo’s Pointy Haired Dilbert blog had its best month ever in June, and he posted some stats to prove it. Congratulations, Chandoo! Pointy Haired Dilbert statistics for June 2009

I’ve written a bit about regression and curve fitting; see Regression Approach to a Simple Physics Problem, Choosing a Trendline Type, and Trendline Fitting Errors. A blog reader asked for help with some sample data that he couldn’t fit. Here is the data. I plotted the data and gave it the hairy eyeball. Not a [...]