Table( Can it find the next value as well as the previous?

Robert Ameeti Robert at Ameeti.net
Wed Feb 20 11:33:02 PST 2008


At 12:10 PM -0600, 2/20/08, David Thompson wrote:

>You're still leaving us to guess at the nature of those tables.

A sampling of the data is:

dataField	keyField
5	8.432286736
10	8.842430608
25	9.493228952
50	10.151682752
75	10.91032724
90	11.541455432
95	11.994954856

The keyField data is obtained by this formula:

keyField = A + B*E + C*E^2 + D*E^3

where A, B, C, & D are obtained by a table of coefficients that are 
used in the above 3rd order polynomial spline equation which defines 
the percentile curves representing the statistical analysis of a 
group of persons of identical age & sex. E is a fixed constant for 
the above equation

I need to know the appropriate keyField values for sequential 
dataField values with increments of 1 between 5 & 95.

Any ideas would be much appreciated.


>The fact that they are floating point would require a few tricks to 
>deal with round off error, but that could still be dealt with as 
>long as the key field comes in equal increments. Also, if this table 
>was the result of a formula, you might be able to use the formula 
>directly.

-- 

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

Genealogy is based on the obviously silly idea that there is no such thing as a bastard.
- Nicolas Martin
<><><><><><><><><><><><><><><><><><>


More information about the Qna mailing list