Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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