Drexel dragonThe Math ForumDonate to 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 Drexel University or The Math Forum.


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

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]

© Drexel University 1994-2013. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.