Sorry, I think I accidentally reverse sorted one column independently of the
other, finding a direct, rather than an inverse correlation. For the inverse
equation:
X = (Elapsed Time)*(Meaured Glucose)/(Time=2 hours)

But, I think you should follow what joe says, and measure your glucose
levels at exactly the same time. You don't want to be estimating numbers
based on an assumption of linearity that is probably not correct.

For the sake of experiment, though, you could test, for example, at 1.6,
1.8, 2, and 2.2 hours in a given day and see how well the transformed values
match your 2 hour time point.
--
Anne Murray


"FinRazel" wrote:

The data you have given follows a linear relationship... if you plot Glucose
level vs. time, on a scatter plot or line graph, you can see this. Since
this is the case, the linear correlation applies: X1/Y1 = X2/Y2. To
normalize, the time you want (X2) is always equal to 2. Y1 is your recorded
Glucose level, and X1 is your recorded time. Your normalized Glucose level
is Y2. In short, if you have time in column A and glucose level in B, fill
this formula into C (normalized): =2*B2/A2

Of course, you should get more data points to see how accurate this is.

Cheers!
--
Anne Murray


"k1ngr" wrote:

I am diabetic and test my blood glucose level 2 hours (approximately) after
eating.
Since I don't always test exactly after 2 hours, how can I normalize the
glucose reading to 2 hours? Below is a sample of my data:

ELAPSED TIME GLUCOSE Normalized
1.9 150 ?
2.2 110 ?
1.7 160 ?
2.3 100 ?
2.0 130 ?

Thanks,
k1ngr