View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Normalizing Data

On Dec 12, 12:11 pm, 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?


I would suggest that you ask your doctor or dietician.

The answer depends on what assumption you can make about the normal
rate of change of glucose levels. Does it change linearly? Does it
decay exponentially? Or do you need conduct an experiment to
determine your individual rate of change?

Off-hand, I would think that any "normalization" procedure would be
presumptuous. The purpose of taking readings at a prescribed time
after eating is to determine how much your glucose level is changing.

Having said all that, it seems to me that your times are not too far
off from exactly 2 hours. So it might be reasonable to assume that
the rate of change is "locally" linear. If you can make that
assumption, the formula might be:

=G1 * A1 / 2

where G1 is your glucose reading, and A1 is the elapsed time in hours.

Medical note: This assumes that your glucose level declines
continuously. In fact, it does not, at least not for normal people.
But when I had fasting glucose tests many years ago, my turn-around
was around 3 to 4 hours later.


----- original posting -----

On Dec 12, 12:11*pm, 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