🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.apps
Article #1692

Re: Excel bug? in MEDIAN function

#1692
From: Michael C. Tanner
Date: Wed, 15 Apr 1992 10:18
20 lines
1572 bytes
In article <1992Apr13.164843.18070@magnus.acs.ohio-state.edu> jbush@magnus.acs.ohio-state.edu (John E Bush) writes:

   P.S. the average of the first example would be 82.666667 and if the median
        of an even numbered sample produced a similar decimal result is where
        the overflow occurs.

Since MEDIAN(range) produced an error and MEDIAN(range,MAX(range),MIN(range))
did not, I suspect the problem is not overflow.  The #NUM! error occurs no
matter how wide the column is, or how I have the number formatted.

At least two people were able to reproduce the error, and at least one did
not.

There are some interesting patterns (such as adding multiples of 2n, n =
number of items, to elements of the list produces errors, too, where other
changes do not), but I don't suppose anybody else cares much about this, so
I'll shut up about it.  But I find it curious, and one of these days I'll call
Microsoft about it and let you know.

-- mike
Technical Details
Message-ID: <MTANNER.92Apr15101842@gmuvax2.gmu.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!news.umbc.edu!gmuvax2!gmuvax2.gmu.edu!mtanner
References: <MTANNER.92Apr13103106@gmuvax2.gmu.edu> <1992Apr13.164843.18070@magnus.acs.ohio-state.edu>

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.apps
Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!news.umbc.edu!gmuvax2!gmuvax2.gmu.edu!mtanner
From: mtanner@gmuvax2.gmu.edu (Michael C. Tanner)
Subject: Re: Excel bug? in MEDIAN function
In-Reply-To: jbush@magnus.acs.ohio-state.edu's message of Mon, 13 Apr 1992 16:48:43 GMT
Message-ID: <MTANNER.92Apr15101842@gmuvax2.gmu.edu>
Sender: mtanner@gmuvax2.gmu.edu (Michael C. Tanner)
Organization: George Mason University, Fairfax Va.
References: <MTANNER.92Apr13103106@gmuvax2.gmu.edu>
 <1992Apr13.164843.18070@magnus.acs.ohio-state.edu>
Date: 15 Apr 92 10:18:42
Lines: 20