Industry Scoreboards III: Analysis

I also used Excel to analyze data for the Industry Scoreboards. For example, I looked at how sales and sales growth varied by geographic region. I extracted trends over time in the lumber wholesale business from a national census of distributors. I extrapolated industry-wide sales trends from an anonymous survey of a subset of the industry. I probed how company membership in hardware co-ops changed after financial irregularities in some co-ops were revealed. Here are a few of my analytical spreadsheets -- again, from the 2005 product to avoid publishing up-to-date information that HCN currently offers for sale.

Here is a 10-year analysis of lumber and building material wholesalers.

Here is an analysis of retailers by store type.

And here is a look at different retail segments by several productivity measures.