"Tom van Stiphout" wrote
That depends. I look at this as a Math
problem, with some X,Y values, and
some additional X-values where we want
to know the Y-value. Typically you'd want
to do some sort of interpolation. Perhaps
straight lines between the known points
(linear interpolation), perhaps a smooth
line (e.g. a cubic spline).
But, without more information on what kind of data it is and/or how it is
derived, we couldn't suggest what method would be appropriate. I remember
taking a numerical analysis class in which, to point out the fallacy of
assuming the missing values could be calculated with whatever method we were
learning, the teacher gave a similar list with some missing values. It
turned out that no one's suggested method would work... it was a list of
room numbers in the building and the number of chairs/seats in the room.
And, as the missing numbers were associated with things like broom closets,
other janitorial rooms, and storage rooms (which contained neither seats nor
chairs) and one storage room that was stacked, jammed-full, floor to ceiling
with extra folding chairs (which contained all the extra chairs for the
entire building)... there was no "method" that could be used to _calculate_
them.
If the ghanley's teacher gave this as an assignment, ghanley had best go ask
for more information. If it is some real-world situation, then ghanley
should carefully consider if it is a problem that lends itself to a
calculated solution.
Larry Linson
Microsoft Access MVP