Monday, December 18, 2006

Healthiest Regions in the U.S.

It is not hard to see why Green Entrepreneurs might be interested in public health studies. Organic products + love for the environment and outdoors + interest in wellness and healthy living, definitely helps raise the health of any community. The important LOHAS market segment can help nurture products and technologies which could have huge public health benefits.

So what are the healthiest regions int the U.S.? The United Health Foundation conducted a study in 2004, where they measured states along several variables and ranked them using a composite index. To visualize the results, I took the data and generated a heat map. Green signifies a State scored higher than the 50 State average, Red signifies the State scored lower, Black means the State scored about the same as the 50 State average. (To enlarge a particular image, click on it.)

MN finished first: a position it has held 9 out of the last 15 years. NH, VT, HI and UT roundup the top five states. States in the Southeast consistently scored below the 50 State average. I have heard factoids that the Southern states lag the rest of the country in terms of income levels. But I have to admit the map still surpised me. These red colored states await Green Entrepreneurs and solutions.

I wanted to "drill-down" into major cities in each state, but alas, I was unable to find data at the city level. Wanting "city-level" data, I decided to look at this ranking of the 50 largest U.S. cities, put together by a different organization (Centrum). Actually, Centrum ranked Metro Areas (or SMSA's), and they used the 2003 estimated population to come up with the 50 largest. Just like any "ranking" or "survey", this one has it's flaws, but Centrum was quite transparent about the data sources and metrics used in the study. The data came from mostly public sources. In coloring a specific Metro Area, I included counties that are part of the Metro Area: in some instances this might show Metro Areas crossing state lines.

The Overall Score and Ranking, is based on a weighted composite scores across several dimensions. (To enlarge a particular image, click on it. Feel free to use these maps.)


I thought the scores in the individual dimensions were interesting. For each dimension, the average score is equal to the (percentile) median: 50.

Mental Wellness was based on the following criteria.


I see that the West Coast is a prime market for stress relief solutions. Washington, DC scored the highest -- but they mean the residents of DC and not Congress!

Lifestyle Pursuits was based on the following criteria.


One can argue with the choice of "lifestyle pursuits" calling into question the stability of the results: different "lifestyle pursuits" would probably result in a very different map.

Physical Activity was based on the following criteria.


L.A. and South Florida finished lower than I expected: that blows our beach culture stereotype. Miami finished near the bottom. If they included Yoga, L.A. would be bright green!

Health Status was based on the following criteria.


These results seem to coincide somewhat with the State rankings above. Michigan which has finished #1 in the Unite Health rankings for 9 out of the last 15 years, is represented by Detroit, which is near the top in this metric.

Nutrition was based on the following criteria.


The Northern states fared poorly, possibly due to higher alcohol consumption and lack of year-round access to fresh fruits and vegetables.

Summary: The non-profit United Health Foundation's State Health rankings reveals opportunities for Green Entrepreneurs and activists based in the Southeastern states. Drilling-down to Metro Areas, I was unable to find city-level data from United Health, and turned to Metro Area rankings from a separate study.

Monday, December 11, 2006

Electricity, Gasoline, and Ethanol By State

A recent NY Times article had an interesting graphic detailing the per capita consumption of electricity and gasoline. (To enlarge a particular image, click on it.)


Wanting a different visual for these consumption rates, I took the data and generated corresponding heat maps. In the next two maps, Green signifies a state consumes less (per capita) compared to the U.S. Per Capita Rate, Red signifies the state consumes more per capita than the nation, Black means the state consumes about the same amount of energy per capita as the entire nation.

In terms of per capita electricity consumption, CA is the most efficient. Is this partly due to the adjustments the state made in response to the 2000-2001 energy crisis?


The answer is, mostly no: the NY Times also featured a graphic which showed that California's per capita electricity consumption has more or less been flat since the late 1970s. While the development of renewables is crucial, efficiency and conservation are just as important. The market for "green" energy solutions includes efficient appliances and other technologies which help people consume less energy. The map above highlights vast untapped markets for such solutions.

The gasoline consumption data shows that the West and the Northeast, are once again, more efficient than the National Average:


High gasoline usage is probably due to the use of farm equipment and trucks. As we next show, some of the gas guzzling states are the leading producers of (corn based) ethanol.

According to the DOE, current average energy yield for corn based ethanol is 25% ("... 25 percent more energy than is used in growing the corn, harvesting it, and distilling it into ethanol"). Most of the ethanol produced in the U.S. is from corn, so it is no suprise that the Midwest dominates:



As cellulosic ethanol becomes more common, I expect the rest of the country to ramp up their production.

The Energy Policy Act of 1992 considers E85 (85% ethanol, 15% gasoline) and blends with even higher concentration of ethanol to be "alternative" fuels. Which states use the most E85 gas? A proxy for consumption of E85 is the number of E85 fueling stations available from the DOE (if you can't pump it, you can't use it):


The earlier map showing gasoline consumption per capita gives a list of "green" states where E85 stations would be popular. A gas station owner in these states, can count on positive publicity and a steady stream of customers. As of early December 2006, California has FOUR E85 stations: two of which are in the Lawrence Berkeley Labs!

Monday, December 04, 2006

Organic Food Sales and Whole Foods Market

Once can cite a litany of anecdotal evidence showing that sales of Organic Foods in the U.S. is growing fast. For official statistics, the Organic Trade Association conducts regular manufacturers survey, which unfortunately, seems to be available only to members. I was able to track down a copy of the 2004 survey, and what follows are some graphs I've put together using the 2004 survey results. (To enlarge a particular image, click on it.)

One measure of growth is the increasing share of Organics in overall food sales: from 1997 to 2003, the share of Organics rose from 0.8% to 1.9%, a 138% rise.


Another way to illustrate the growth in Organic Foods is to graph the time series of sales of Organic Foods and all foods. The problem with drawing the graph of these two time series is that the magnitude of the two time series are very different: Organic Food Sales are a small proportion of total food sales. A common trick is to normalize both time series so they start at a common initial value (say 100), then use their respective year-over-year growth rates to plot the rest of the graph. In the graph below we plot 4 times series in this manner:


The total sales of Whole Foods Market (organic and conventional, food and non-food items) closely tracks the sales in Organic Foods. The high correlation reflects the importance of Whole Foods within the Organic Foods industry, and the importance of Organic Food sales to Whole Foods' total sales. What the graph suggests is that a rough estimate of the year-over-year growth in Organic Food sales, is the growth in Whole Foods' total sales.

Between 1997 and 2003, Whole Foods sales went up 200%, compared with a 191% growth in Organic Foods. Because of its scale and efficiencies derived from its size, one expects Whole foods to grow slightly faster than the Organic Food industry. If one factors in the growth in Whole Foods retail stores (sales per square foot), Whole Foods grew a more modest 14%. Total food sales grew 25% between 1997 and 2003.

The remaining graphs are drawn from the sales of Organic items in 2003. Which categories are growing the fastest? To address this question we use a treemap. In a treemap, the size of the square reflects the size of the category, while its color reflects the rate-of-change of the category. Green means a category is growing, Black means it is relatively flat, Red means the category is declining. In the following treemaps, the size of a square reflects the 2003 sales in the given category, the color corresponds to the 2003 year-over-year growth. (To enlarge a particular image, click on it.)


Not suprisingly, the smallest category (Meat/Fish/Poultry) grew the fastest. The advantage of a treemap is that you can encapsulate two pieces of information in one graph: the size of a category and its growth rate. The alternative approach is to use two separate bar charts:




Here is a treemap for the Organic Non-Foods categories:


Finally, here is a 2-level treemap of Organic Foods and Non-Foods, to show the relative sizes and growth rates of all the categories:


Conclusion: Organic Foods sales are growing much faster than sales of non-organic food products. The share of Organic Foods in overall foods sales more than doubled between 1997 and 2003. Whole Foods Markets total sales, closely tracks the total sales of all Organic Foods: an estimate for the year-over-year growth in the sales of Organic Foods, is the corresponding change in the Total Sales of Whole Foods Market.