uk.sci.weather (UK Weather) (uk.sci.weather) For the discussion of daily weather events, chiefly affecting the UK and adjacent parts of Europe, both past and predicted. The discussion is open to all, but contributions on a practical scientific level are encouraged.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #12   Report Post  
Old December 30th 12, 08:52 AM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Jul 2011
Posts: 37
Default The Weather "Means" rule and spreadsheets

So we seem set on 'the throw to the odd' for sorting a MONTHLY mean - but what about seasonal and YEARLY means?

For a Yearly mean would you use
A - the mean min + mean max divide by 2 and apply the throw to the odd rule, or
B - the sum of the 12 monthly means divide by 12 and then apply the throw to the odd?
  #14   Report Post  
Old December 30th 12, 10:28 AM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Oct 2005
Posts: 3,301
Default The Weather "Means" rule and spreadsheets

"Norman" wrote in message ...

In practice, I suspect that in most cases you would end up with the same
answer
using either method.

Hi, Norman,
Agreed, even MetO site thermometers are only accurate to +-0.2C so I can not
see the point of such worry about accuracy with means! Just throw to the odd
for goodness sake, I've been doing it for over 40 years. It ain't that
difficult!
As Graham said, it's all about the values around 0C.
Ken
Copley
Teesdale

  #15   Report Post  
Old December 30th 12, 10:42 AM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Jul 2011
Posts: 37
Default The Weather "Means" rule and spreadsheets

I'm sure that accuracy is important and obviously it can make a difference of 0.1c


  #16   Report Post  
Old December 30th 12, 10:46 AM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Jul 2011
Posts: 37
Default The Weather "Means" rule and spreadsheets

On Sunday, 30 December 2012 10:42:35 UTC, wrote:
I'm sure that accuracy is important and obviously it can make a difference of 0.1c


Also, dependent depending on A or B you do get a different answer and the years that one changes, the other won't.
  #17   Report Post  
Old December 30th 12, 10:58 AM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Oct 2005
Posts: 3,301
Default The Weather "Means" rule and spreadsheets

wrote in message
...

I'm sure that accuracy is important and obviously it can make a difference
of 0.1c

But the best thermometers don't work to that accuracy, far from it. Nor do
the screens. Nor do the exposures, even for MetO sites. I think the
difference of throwing to the odd or even is lost among other factors but
I'll say no more and continue to throw to the odd as the good old MetO has
told me to.
Ken

  #18   Report Post  
Old December 30th 12, 12:47 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Dec 2009
Posts: 5,538
Default The Weather "Means" rule and spreadsheets

The "different" behaviour occurs at the mid-point between 10ths i.e.
10.05, 10.15, 10.25, etc. This is where "throwing to the odd occurs (if
you are measuring to the nearest 10th).
I can't remember either what the "name" of this rounding is


It is called "rounding half to odd", not surprisingly!

See http://en.wikipedia.org/wiki/Rounding#Round_half_to_odd

--
Freddie
Bayston Hill
Shropshire
102m AMSL
http://www.hosiene.co.uk/weather/
https://twitter.com/#!/BaystonHillWx for hourly reports


  #19   Report Post  
Old December 31st 12, 09:36 AM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Sep 2010
Posts: 174
Default The Weather "Means" rule and spreadsheets

Thanks for all the replies !!!

Appeared to have sparked a little interest in the subject

best wishes for the new year

Paul C
  #20   Report Post  
Old December 31st 12, 02:36 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Nov 2003
Posts: 935
Default The Weather "Means" rule and spreadsheets

On 31/12/2012 09:36, Paul Crabtree wrote:
Thanks for all the replies !!!

Appeared to have sparked a little interest in the subject

best wishes for the new year

Paul C


You would have to create a UDF to allow you access to the VBA macro
implementation or roll your own very clumsy implementation via a string
intermediate stage. More details about Excel rounding online at:

http://support.microsoft.com/kb/196652

It still isn't pretty since you will have to add and subtract 1 in the
LSB to get weathermens rounding as opposed to bankers rounding.


--
Regards,
Martin Brown


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colin Finch's 38F minus rule Scott W uk.sci.weather (UK Weather) 13 December 17th 14 07:02 AM
Useful rule of thumb... exmetman[_2_] uk.sci.weather (UK Weather) 3 May 16th 14 07:24 AM
Humidity Slide Rule Dave Wheeler uk.sci.weather (UK Weather) 3 December 10th 06 07:59 AM
Rooftop to rule on 'white Christmas' Norman Horrocks uk.sci.weather (UK Weather) 5 December 22nd 04 11:26 PM


All times are GMT. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Weather Banter.
The comments are property of their posters.
 

About Us

"It's about Weather"

 

Copyright © 2017