stddev -> %

Is there a function in Oracle that will convert variance into a percent likelihood? Specficially, I have both an average (A) and a standard deviation(SD) for a set of measurements. What I would like to do is express a single NEW measurement (M) as being within x% likelihood.

I believe that |M-A| / SD will give me how many SDs the measurement is from the average. The function that I'm trying to find would convert that into the % of measurements that are that close or closer to the average. Because I would like to do this with some rather small sets of measurements (but treat it as though it came from a large number of measurements), I want to use a calculated value rather than the imprecise value obtained by comparing with the acutal values, e.g., if there were 8 values, then new one would be placed to within a range of 12.5%. I'd like to derive a more precise value depend where the new value lies between the closest existing measurements.

Is there such a function or good way to calculate this % value?

TIA
Cory Received on Sun Mar 14 2004 - 16:59:12 CST