"Bonos Ego" wrote in message
...
I was a bit bored at work the other day, so thought I would advance my
Excel skills, I have produced an analysis of Central England
Temperatures (CET) for each month & season since 1971 with its
Standard Deviation from Mean over the same period, see link
http://i393.photobucket.com/albums/p...dDeviation.jpg

Each month & season is colour coded as follows.

= 3 Standard Deviation from Mean = Purple
= 2 Standard Deviation from Mean = Blue
= 1 Standard Deviation from Mean = Green
within 1 Standard Deviation from Mean = White
= 1 Standard Deviation from Mean = Yellow
= 2 Standard Deviation from Mean = Beige
= 3 Standard Deviation from Mean = Red

For more information about Standard Deviation, see
http://en.wikipedia.org/wiki/Standard_deviation

February 1986 and December 1981 were certainly something special. Shown up
nicely here.

If you want to further your skills and enhance the data - included skew's
into your analysis. This would create a better balance in the lack of
notable warmer than average departures, whilst cutting down the number of
outstanding cooler ones.
I think the excel formula would be thus;
AVERAGE(range)+/-XSTDEV(range)+SKEW

I use this formula myself for daily figures (maximum and minimum), where
2STDEV+SKEW assists in defining an unusual temperature and 3STDEV+SKEW tends
to mark what should be either the limit or a very outstanding value indeed.

Without including a skew, maximum or positive anomallies tend to get
overlooked, whilts minimum or negative values are too easily encapsulated.
Alex.