Article View: comp.sys.mac.apps
Article #1695Re: Excel bug? in MEDIAN function
From: Mark H. Nodine
Date: Wed, 15 Apr 1992 15:45
Date: Wed, 15 Apr 1992 15:45
48 lines
1285 bytes
1285 bytes
In article <MTANNER.92Apr13103106@gmuvax2.gmu.edu>, mtanner@gmuvax2.gmu.edu (Michael C. Tanner) writes: |> I have been keeping my grade book in an Excel spreadsheet, and noticed while |> entering scores last night that something funny happened. At one point, in |> the position where I'm keeping a median of the column I was entering, it |> changed from a number to #NUM!, then changed to a number when I entered the |> next score. So I started playing around to see what was going on. |> |> Here's the scores at the point the error occurred (sorted): |> |> 100 |> 96 |> 92 |> 92 |> 92 |> 92 |> 92 |> 88 |> 88 |> 84 |> 84 |> 84 |> 76 |> 72 |> 0 |> 0 Excel looks pretty sick to me on this one. I just did the median of this data set (based on yours): 100 96 92 92 92 92 92 88 0 0 0 0 0 0 0 0 and got a median of 44 (!). --Mark
Technical Details
Message-ID:
<1992Apr15.154510.29839@cs.brown.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!brunix!cs.brown.edu!manReferences:
<MTANNER.92Apr13103106@gmuvax2.gmu.edu>Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.apps Path: arc1-ca.pugleaf.net!sparky!uunet!brunix!cs.brown.edu!man From: man@cs.brown.edu (Mark H. Nodine) Subject: Re: Excel bug? in MEDIAN function Message-ID: <1992Apr15.154510.29839@cs.brown.edu> Sender: news@cs.brown.edu Organization: Brown Computer Science Dept. References: <MTANNER.92Apr13103106@gmuvax2.gmu.edu> Date: Wed, 15 Apr 1992 15:45:10 GMT Lines: 50