Article View: comp.sys.mac.apps
Article #1692Re: Excel bug? in MEDIAN function
From: Michael C. Tanner
Date: Wed, 15 Apr 1992 10:18
Date: Wed, 15 Apr 1992 10:18
20 lines
1572 bytes
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!mtannerReferences:
<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