The Math Forum


Math Forum
 Ask Dr. Math
 Discussions
 Internet Newsletter
 MathTools
 Problems of the Week
 Teacher2Teacher
 Teacher Exchange
 Workshops

Search All of the Math Forum:
Browse our Internet Mathematics Library

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.


Math Forum » Discussions » Math Topics » alt.math.recreational

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: Calculating averag but leaving highest and lowest number out ?
Replies: 4   Last Post: Apr 19, 2005 12:18 PM

Advanced Search
Reply to this Topic Reply to this Topic

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
hihihi

Posts: 2
Registered: 4/19/05
Re: Calculating averag but leaving highest and lowest number out ?
Posted: Apr 19, 2005 7:09 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

mwelinder@gmail.com wrote:

> Gnumeric's TRIMMEAN most certainly sorts. The example from the
> beginning
> of this thread yields 3.333... as expected.

Thats what i get also.
But with my actual 6 numbers it goes wrong.

21.5
20.2
22.8
20.7
22.5
29.9

I can't see what i did wrong.
Here is a small example
http://home.wanadoo.nl/hihihi/temp/gnumeric-trimmean-perhaps-bug.gnumeric


--
Ever heard about "global dimming" ? It can mess up your future.
http://www.bbc.co.uk/sn/tvradio/programmes/horizon/dimming_trans.shtml
Email address: hihihi wanadoo nl. Replace the spaces with @ and .

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum at NCTM 1994-2018. All Rights Reserved.