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
  #1   Report Post  
Old December 29th 12, 12:46 PM 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

Hi
I hope someone can answer this question after a good debate with a friend of mine.

I was calculating some Mean Temps- max and min etc over the last year. My excel spreadsheet carefully rounded the data up to one decimal point. But we discovered that the data didnt match and we hadnt been using the "means rule" where you have to round up or round down depending on the value. My friend calculated the final sum manually, but of course being lazy I want my spreadsheet to do it for me.

E.G of means rule ?
15.05 change 15.1
15.15 leave at 15.1
15.25 change to 15.3
15.35 leave at 15.3
15.45 change to 15.5
15.55 leave at 15.5
15.65 change to 15.7
15.75 leave at 15.7
15.85 change to 15.9
15.95 leave at 15.9
16.05 change to 16.1

Does anyone know how to "programme" a spreadsheet to round up the correct "weather" way to avoid manual calculation.

hope all this makes sense, I did look in the Mr Burts weather observers handbook but I cant find anything relating to this in there.

regards
Paul C
Brampton, Cumbria
www.bramptonweather.co.uk

  #2   Report Post  
Old December 29th 12, 12:51 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Nov 2012
Posts: 591
Default The Weather "Means" rule and spreadsheets

I thought that you always round up if 5 or greater, i.e., 15.15 will
always become 15.2, and so on.

I have not heard of any other way of doing this (until now).

--
Nick G
Otter Valley, Devon
20 m amsl
http://www.ottervalley.co.uk
  #3   Report Post  
Old December 29th 12, 01:01 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Jan 2009
Posts: 6,081
Default The Weather "Means" rule and spreadsheets

Nick Gardner wrote:

I thought that you always round up if 5 or greater, i.e., 15.15 will always
become 15.2, and so on.

I have not heard of any other way of doing this (until now).


The standard meteorological method is to "throw it to the odd". Therefore,
15.15 becomes 15.1 whereas 15.25 becomes 15.3. I believe the logic in this is
to eliminate systematic bias that would be caused if rounding was always up (or
down).

--
Norman Lynagh
Tideswell, Derbyshire
303m a.s.l.
  #4   Report Post  
Old December 29th 12, 01:11 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Dec 2011
Posts: 475
Default The Weather "Means" rule and spreadsheets

On 29/12/2012 13:01, Norman wrote:
Nick Gardner wrote:

I thought that you always round up if 5 or greater, i.e., 15.15 will always
become 15.2, and so on.

I have not heard of any other way of doing this (until now).


The standard meteorological method is to "throw it to the odd". Therefore,
15.15 becomes 15.1 whereas 15.25 becomes 15.3. I believe the logic in this is
to eliminate systematic bias that would be caused if rounding was always up (or
down).

.... indeed: I've not found a way to do this in Excel and I have to keep
manually checking so as to over-write the automatic calculation it
offers. As noted above, in meteorological statistical use, as far as I
know, we've always 'thrown to the odd'.

The only deviation to this was with actual pressure observations (not
climatological returns) where 0.5mbar was always thrown *down*: this
being 'safer' when setting altimeters etc.

Martin.


--
West Moors / East Dorset
Lat: 50deg 49.25'N, Long: 01deg 53.05'W
Height (amsl): 17 m (56 feet)
COL category: C1 overall
  #5   Report Post  
Old December 29th 12, 02:24 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Oct 2004
Posts: 4,814
Default The Weather "Means" rule and spreadsheets

On 29 Dec 2012 13:01:30 GMT
"Norman" wrote:

Nick Gardner wrote:

I thought that you always round up if 5 or greater, i.e., 15.15
will always become 15.2, and so on.

I have not heard of any other way of doing this (until now).


The standard meteorological method is to "throw it to the odd".
Therefore, 15.15 becomes 15.1 whereas 15.25 becomes 15.3. I believe
the logic in this is to eliminate systematic bias that would be
caused if rounding was always up (or down).


According to what I remember of my HNC Numerical Analysis course, the
standard method is to "throw to the even;" I assume the meteorological
reason for being the odd one out is to throw away from zero.

--
Graham P Davis, Bracknell, Berks.
Time flies like an arrow but fruit flies like a banana. [Marx]


  #6   Report Post  
Old December 29th 12, 07:01 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Sep 2011
Posts: 359
Default The Weather "Means" rule and spreadsheets

On Saturday, December 29, 2012 2:24:24 PM UTC, Graham P Davis wrote:
On 29 Dec 2012 13:01:30 GMT

"Norman" wrote:



Nick Gardner wrote:




I thought that you always round up if 5 or greater, i.e., 15.15


will always become 15.2, and so on.




I have not heard of any other way of doing this (until now).




The standard meteorological method is to "throw it to the odd".


Therefore, 15.15 becomes 15.1 whereas 15.25 becomes 15.3. I believe


the logic in this is to eliminate systematic bias that would be


caused if rounding was always up (or down).






According to what I remember of my HNC Numerical Analysis course, the

standard method is to "throw to the even;" I assume the meteorological

reason for being the odd one out is to throw away from zero.



--

Graham P Davis, Bracknell, Berks.

Time flies like an arrow but fruit flies like a banana. [Marx]


Observers Handbook P 111 Para 8.1.3

"When the instructions specify that the reading is to be reported or recorded only to the nearest whole degree the procedure is as follows;
If the number of tenths in the corrected value is five, "throw to the odd" i.e. round off to the nearest odd whole number; for example 6.5 = 7, 7.5 = 7 8.5 = 9."
  #10   Report Post  
Old December 29th 12, 11:18 PM posted to uk.sci.weather
external usenet poster
 
First recorded activity by Weather-Banter: Aug 2011
Posts: 925
Default The Weather "Means" rule and spreadsheets

On Sat, 29 Dec 2012 22:27:22 -0000, Alan LeHun wrote:
10.12 10.1
10.19 10.1
10.22 10.3
10.26 10.3
10.15 10.1
10.25 10.3


That's not quite right. 10.12 - 10.1 is ok, but 10.19 - 10.2, 10.22
- 10.2. The last 3 are ok too. 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). 10.05 - 10.1, 10.15 - 10.1, 10.25 - 10.3, 10.35 -
10.3 and so on. In Java you can do this type of rounding - but I
can't remember either what the "name" of this rounding is, nor which
package the rounding functions are in. I will look them both up in
the morning.

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


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 06:43 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