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.

Monday, November 27, 2006

Whole Foods Locations

Whole Foods is the big player in Organic groceries, and arguably, for the entire LOHAS Industry (Lifestyles of Health and Sustainability). I will be devoting some future posts to understanding Whole Foods. With a market cap of $6.7B and no signs of slowing down, Whole Foods has tried to stay true to its values, inspite of its rapid growth.

To understand the market for Green products, it is good to know how Whole Foods selects it's store locations. Whole Foods stores tend to be located in upper income, liberal leaning enclaves. As green products become more mainstream and affordable, will we see Whole Foods expand beyond their current geographic areas?

Here is a map of Whole Foods stores in the mainland U.S. I aggregated stores by county: LA county has the highest number of Whole Foods stores. (To enlarge, Click on an image.)


One can also aggregate the number of active locations by State:


In these next maps I added stores currently in development. The first graph is an aggregate at the county level, and the second graph is an aggregate at the state level:



Illinois is joining Texas and Massachusetts with just below 20 active and pending locations, most of the stores serve the Chicago metro area. California is far and away their biggest market, further cementing the state's reputation for being at the leading edge of lifestyle trends.

At this time, Whole Foods is expanding carefully, and is generally sticking to the same metro areas. The market for organic foods is growing, and I have to believe there is an opportunity for someone to capture this market in the states & metro areas that Whole Foods is currently ignoring. Will Wild Oats dominate, or will the "mainstream" grocery chains slowly capture the market for Organic foods, in these other regions? From a logistics and distribution POV, the mainstream grocers who are already in these regions can easily expand their offerings of Organics foods. So how does Whole foods keep growing at a rate to make its investors happy? I think their strategy is clearly to keep adding to their current locations, and to take advantage of their scale and distribution centers.

Monday, November 20, 2006

2006 SF Greenfest: Exhibitor Analysis

Walking around the recent SF Green Festival (Greenfest), I was struck by the number and variety of exhibitors. The festival keeps growing, and this year, the Concourse really felt crowded. Who were the exhibitors? The resulting analysis is based on data from the festival's own listings, which I supplemented with descriptions from the exhibitors' web sites. I was interested in uncovering the common "themes or topics" in this year's festival.

First some simple counts: there were 236 exhibitors across 23 categories, with some exhibitors listed in more than one category:


The graph confirms my experience while walking around the festival: there were a lot of publishers, clothing, and health and beauty products. It was a San Francisco festival, so it is not a surprise that most of the exhibitors were from California:


Most of the exhibitors were from the West Coast: California (148), Oregon (17), and Washington (12). Within California, San Francisco (45) and Alameda (31) counties were dominant:


If I were an organizer, I would try to increase the number of exhibitors from the Peninsula (San Mateo and Santa Clara), and help nurture Green Entrepreneurs in those nearby counties. Having more exhibitors from the Peninsula would also increase attendance from Silicon Valley.

Topics and Themes
The Festival was ground zero for the LOHAS Industry (Lifestyles of Health and Sustainability): I was interested in how companies appeal to members of this growing space. I decided to use Exhibitors' own company statements/descriptions/philosophies to see if there were any dominant themes and topics. If one wants to understand this segment, one might as well understand how the Green Entrepreneurs position themselves in the marketplace!

Using recent developments in (unsupervised) machine learning and bayesian computation, an analyst can now analyze text data to uncover latent topics. I started with the descriptions provided by the exhibitors, and supplemented it with descriptions from an exhibitor's own web site, whenever I felt that I needed a longer "mission or product statement". Using a text mining algorithm, I uncovered 25 themes/topics from the exhibitors' "mission or product statements". An interesting output of the algorithm, is that any individual "mission or product statement" can cover one or more topics. As an example, a Fair Trade coffee maker can talk about Fair Trade, the environment, and organic agriculture. Finally, one can measure the relative size of the different topics:

"making the world a better place" and "nutrition & organic foods" were the two most common topics discussed: if one were to examine the "missions & product statements" of the 200+ exhibitors, these are the two most commonly mentioned subjects. The one caveat about the size of topics: size is measured by the amount of text devoted to a topic. In the course of supplementing text for certain exhibitors, I may have inadvertently added to the size of certain topics. I suspect that's what happened in the case of "socially responsible finance".

Conclusion
The SF Green Festival continues to grow, and this year included 236 participating exhibitors. Since the conference was held in SF, most of the exhibitors came from the West Coast. Among California exhibitors, SF and Alameda county were dominant. For 2007, I recommend the festival organizers try to recruit more exhibitors from nearby San Mateo and Santa Clara counties.

Using a text mining algorithm, we studied themes and topics used in the exhibitors "mission and product statements". A similar and more thorough analysis may be useful to marketers in the fast-growing LOHAS Industry (Lifestyles of Health and Sustainability).

Opening Salvo

Welcome to Green Markets.

We hope this blog can serve as a resource for "Green" entrepreneurs. Our posting frequency will be weekly, or whenever it is that we come across interesting data!

If you have data or topics you want us to cover, post a comment and we will evaluate your request.