Wednesday, May 20, 2009

Oh Magic 8 Ball... will it rain on Crab Fest?

It keeps telling me "Ask Again Later". So, while waiting for "later" and making it look like I'm actually doing some important statistical data research by having Excel open whenever my boss wanders past. This should appease our curiosity slightly more than the old magic 8 ball (which I included at the bottom of the post if you want to see if it gives you anything better.

Click to enlarge the graph and you can see the high and low temperature and the amount of precipitation from 1980-2008. There does seem to be a slight pattern to it lately, every third year since 97 has been warm with no rain, and since the hottest crab Crab Fest since 1980 was in 2006 add three more years, statistically we're due for some sun at least. The precipitation and temps are averaged the span of the festival, so it doesn't account for rainy parade day and then the rest of it sunny. Interesting to see it was mild and slightly rainy through most of the 80s, and hit some sweet spikes in '93, '97, the year 2000 and '02.

Dang... now the boss is looking over my shoulders and realizing what I've been wasting my afternoon on. Good thing it piqued their interest too... otherwise I'd be in big trouble. I swear I was just learning how to make charts in Excel boss.

No comments: