🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Excel bug? in MEDIAN function

#1695
From: Mark H. Nodine
Date: Wed, 15 Apr 1992 15:45
48 lines
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!man
References: <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