I had already been messing around with weather data, so I decided to throw together an Excel spreadsheet that can calculate streaks within a temperature range. My approach actually allows temperature ranges for both highs and lows, but this challenge had me limit highs to 70-79 degrees with no limits for the lows. Assuming all of my data and (more importantly) my formulas are correct, we tied the previous record of 14 on August 31. With the first three days of the month already reaching the same range, we have clearly set the record with 17 and counting.
Longest Streaks for 70-79 Degree Temperatures | ||
Rank | End Date | Streak |
1 | 9/3/2012 | 17 |
2 | 8/31/1995 | 14 |
2 | 8/13/2003 | 14 |
2 | 8/19/2011 | 14 |
5 | 9/15/2008 | 12 |
6 | 9/7/1957 | 11 |
6 | 8/2/1987 | 11 |
6 | 7/31/2007 | 11 |
9 | 9/26/1967 | 10 |
10 | 6/20/1951 | 9 |
10 | 8/22/1983 | 9 |
10 | 9/18/1998 | 9 |
10 | 8/3/2011 | 9 |
No comments:
Post a Comment