Friday, August 29, 2008

Well since I wanted to start a new thread, and you were virtually begging me to make another speadsheet/chart about some random nonsense here goes. I went to and got the average and record highs and lows for every day of the year. This data seems to range from about 1926 to about 2005 and is for West Berlin (probably for somewhere near here, but they don't tell you where).

In sundata you can see the sunrise and sunset times for the year, as well as the length of the day. Nothing to interesting here, just that it's not perfectly symmetrical.

Next in tempavg you can see all the averages/records for the year. Some interesting things here, first late January is the colder time of year, late July the hottest. Nothing shocking, the records though show something that surprised me. The difference between the coldest record low in January, and the warmest record low in July is about 75 degrees, compare that to the difference in the two extreme highs of only 40 degrees. In case you were wondering that huge cold spike is -25 on Feb 9th 1934. As you look at the lines for the records the two things that stick out are that the low has a sudden drop in mid January to mid February. Second is that the record high doesn't vary that much. This seems mainly because there seems to be something stopping it from rising much above 100. The best I could come up with for this would be because we have a large mass of cold area (Canada) near us, but we don't really have any large hot area.

Last we come to temprec, which list how many days in a given year hold the current record low or high. This chart doesn't have a lot of data and there is some chance that they moved the place where these records are recorded at some point, but I still think it shows some interesting things. First I notice that there are almost always more record lows than highs. Most of the spikes of highs have a larger spike of colds in the same year, or in the next year. The two times when there were more highs than lows is the first decade and last two decades of data. I think the first group can be explained because we know the high doesn't go that high ever, thus in the first few years they were recording the data most of the highs just haven't been beaten. However, I'd bet if you had 50 years more data into the past you'd see that group move to the start of that data. The recent data also shows some interesting trends. You can see there are very few lows, however, there are also either few highs or many highs. In other words it seems as though the last 20 or so years have been more mild, with occasional increased wild spikes of heat.

I'm not sure what any of this means, but I am certain it's ground breaking, and will be expecting the grant money any day now.

No comments:

Post a Comment