🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Excel bug? in MEDIAN function

#1622
From: John E Bush
Date: Mon, 13 Apr 1992 16:48
20 lines
1632 bytes
Well, I have written a gradebook program that uses the median method of
calculating grades.  The Median is a statistical method for finding the
middle grade rather than the average grade.  For example, 100, 98, 50
would produce a median of 98 and an average of 82.6.  If the number of
samples in the group is an even number say 4, then the average of the
middle two numbers is taken to produce the median.  So, if we had 100, 98,
96, and 50 as scores, the median would be the average of 98 and 96.  The
average would be calculated by adding all scores and dividing by the total.

Without looking too hard, I would say that the error is occuring when
there is an even number of scores in the sample, and the column just isn't
wide enough to display the entire score.  If you set the column value
format to display only one decimal place or something similar your problem
should be solved.

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.

Eric
Technical Details
Message-ID: <1992Apr13.164843.18070@magnus.acs.ohio-state.edu>
Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!jbush
References: <MTANNER.92Apr13103106@gmuvax2.gmu.edu>

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.apps
Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!jbush
From: jbush@magnus.acs.ohio-state.edu (John E Bush)
Subject: Re: Excel bug? in MEDIAN function
Message-ID: <1992Apr13.164843.18070@magnus.acs.ohio-state.edu>
Keywords: Median
Sender: jbush@magnus.acs.ohio-state.edu (J. Eric Bush)
Nntp-Posting-Host: bottom.magnus.acs.ohio-state.edu
Organization: The Ohio State University
References: <MTANNER.92Apr13103106@gmuvax2.gmu.edu>
Date: Mon, 13 Apr 1992 16:48:43 GMT
Lines: 20