In article ,
says...
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.


Ok. I see where your going. Excel does not appear to have such a
function, and if that is so, you would have to complicate things with an
IF function. Hey ho.

=IF(MOD(Cell*10,1)=0.5,(ODD(Cell*10-1))/10,ROUND(Cell,1))


10.12 10.1
10.19 10.2
10.22 10.2
10.26 10.3
10.15 10.1
10.25 10.3

--
Alan LeHun
Reply-to is valid. Add "BPSF" to subject: to bypass spam filters.

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?

wrote:

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?

A is correct, provided the mean min and mean max are the means of 365 (or 366)
daily figures.

B is incorrect as the individul months are of differing lengths.

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

--
Norman Lynagh
Tideswell, Derbyshire
303m a.s.l.

"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

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

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.

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

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

Thanks for all the replies !!!

Appeared to have sparked a little interest in the subject

best wishes for the new year

Paul C

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