MEDIAN Function? (OpenInsight Specific)
At 24 JAN 2001 09:14:22AM Mark Glicksman wrote:
Is there a MEDIAN function built into OI for use with numeric fields? (I know there is an AVEREAGE function)
Thanks,
Mark
glicks@compuserve.com
BG-Map Botanical Garden Mapping System [img]http://www.bg-map.com/bgmap.gif[/img]
At 24 JAN 2001 09:18AM Don Miller - C3 Inc. wrote:
Mark ..
No MEDIAN function. The problem is that it has to calculate the value at the end (like AVERAGE or TOTAL). It would be possible to do it in hand-coded BASIC+ reports. Sorry…
Don Miller
C3 Inc.
At 24 JAN 2001 11:01AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Or one could create a symbolic - if one used V119 and the spread of values was not too high performance should be acceptable.
World Leaders in all things RevSoft
At 24 JAN 2001 11:46AM Don Miller - C3 Inc. wrote:
Sprezz .. might work. Pretty neat idea. The problem might be discontiguous data that might lead to overflow or underflow errors. In that case, GOK what might happen. Keep on truckin' though.
Don Miller
C3 Inc.
At 24 JAN 2001 11:57AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Kicked into being imaginative by the current client. They have their own version of Rightdex that instead of storing keys in %RECORDS% stores a single byte in a 64K string showing whether the key is used - byte 1=record key 1 etc etc. This way they can use a "Rightdex" on 64,000 keys! I suppose if we wanted to use bit operators we could use "Rightdex" on half a million records….
World Leaders in all things RevSoft
At 24 JAN 2001 02:29PM Don Miller - C3 Inc. wrote:
Reminds me of my Scheduling App. Staff availability is a bitmap represnting 24 hour day (in 15 min increments) as 2 32-bit elements with open (available) as a 0 and used as a 1. Total 96 bits per day 7 days. First half (48 bits) is the AM portion, last half is the PM version. The free time search simply looks for bit patterns as integers. Didn't think of the used/unused keys bit. Pretty slick.
Don M.
At 26 JAN 2001 07:59AM Alun Hutchings wrote:
Don't know whether this is of any use, but I've handled this programmatically in an application that manages candidates on an educational course. The rbasic event code selects the required rows and calculates n, min, max, mean, median, std dev, cv and skewness. If you would like a copy of the code, please email me at HutchingsAD@cardiff.ac.uk