Loftus,  Here's the file.
If you break the date column up into three separate columns  for month, day, and year then you can use subtotals and/or pivot tables to  analyze the data a little more quickly and dynamically.
For example, you  might want to look at the extremes or averages for any particular month or  year or whatever.
I c an help you do this if you want.
Remember that this  is a very limited data set statistically speaking, especially considering  that the last 3 winters were far above normal.
If you want to investigate  what the possible extreme scenarios are based on past history then I can get  you the data for many decades further back if wish.
Just let mw know.
Thanks,

Chicago Temps
Loftus, Here's the file.
If you break the date column up into three separate columns for month, day, and year then you can use subtotals and/or pivot tables to analyze the data a little more quickly and dynamically.
For example, you might want to look at the extremes or averages for any particular month or year or whatever.
I c an help you do this if you want.
Remember that this is a very limited data set statistically speaking, especially considering that the last <NUMBER> winters were far above normal.
If you want to investigate what the possible extreme scenarios are based on past history then I can get you the data for many decades further back if wish.
Just let mw know.
Thanks,
break date column especially use subtotals considering number winters loftus file know thanks based past history extreme scenarios dynamically example want tables analyze data