When I tried it I got increasing values as time increases. I should be
getting decreasingvalues, e.g. for 1.9 I should get a value less than 150.

"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