Article View: comp.sys.mac.apps
Article #1622Re: Excel bug? in MEDIAN function
From: John E Bush
Date: Mon, 13 Apr 1992 16:48
Date: Mon, 13 Apr 1992 16:48
20 lines
1632 bytes
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!jbushReferences:
<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