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

"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.

In article
,
Bonos Ego writes:
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

Thanks. Very interesting, though I'm not sure that I could draw any
conclusions from it.
--
John Hall
"Acting is merely the art of keeping a large group of people
from coughing."
Sir Ralph Richardson (1902-83)

On Apr 5, 5:55*pm, John Hall wrote:
In article
,
*Bonos Ego writes:

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

Thanks. Very interesting, though I'm not sure that I could draw any
conclusions from it.
--
John Hall
* * * * * *"Acting is merely the art of keeping a large group of people
* * * * * * from coughing."
* * * * * * * * * * * * * * * Sir Ralph Richardson (1902-83)

I thought it was interesting too!

But what is noticeable is that this cold winter with a standard
deviation of 2.4 is unique in the last 10 years, much as the warm
summer in 1976 was unique in the 1970s. Once in ten year events do
happen!

Cheers, Alastair.

On 6 Apr, 19:23, Alastair wrote:
On Apr 5, 5:55*pm, John Hall wrote:
,
*Bonos Ego writes:

http://i393.photobucket.com/albums/p...dDeviation.jpg

Thanks. Very interesting, though I'm not sure that I could draw any
conclusions from it.

It's easy to see you will never make a climato.

But what is noticeable is that this cold winter with a standard
deviation of 2.4 is unique in the last 10 years, much as the warm
summer in 1976 was unique in the 1970s. Once in ten year events do
happen!

Any idea how often?

(Not that I have any interest in statistics.)

On 2010-04-05 17:39:00 +0100, Bonos Ego said:
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

Thanks from me for this too. It's very interesting, but to my
statistical eye it all looks pretty random! Which is, of course, what
we would expect.

--

Trevor
Windblown in Lundie, near Dundee
http://www.personal.dundee.ac.uk/~taharley/