29 Nov 2000, 08:46 UTC
Chicago Temps
- From
- V Charles Weldon v.weldon@enron.com
- Date
- Wed, 29 Nov 2000 00:46:00 -0800 (PST)
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, Charlie