View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
k1ngr k1ngr is offline
external usenet poster
 
Posts: 15
Default Normalizing Data

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