Averaging glucose meter readings - Page 2

Go Back   The Diabetes Forum Support Community For Diabetics Online > Diabetes Forum Start Here > Diabetes Forum Lounge

Diabetes Forum Lounge The Diabetes Forum lounge is the more social area of the community. Please feel free to drop in, and discuss anything thatís on your mind. Use this area for off topic discussions, making friends and being social.


Like Tree12Likes

Averaging glucose meter readings - Page 2


Closed Thread
 
Shared Thread Thread Tools
Old 07-05-2012, 19:56   #11
hld12
Guest
 
Posts: n/a


Default

Quote:
Originally Posted by Miss_Blue View Post
For the most part, I don't do anything. A few months ago, though, I decided to do a fasting average, a complete average of all my readings, and the standard deviation. Excel can do all the math for you, but you do need to know how to enter the information in the correct format.
What I usually do is total up the column and divide that number by however many readings I have. I have Microsoft Works spreadsheet, so I can't do all the things that Excel does.

 
Old 07-05-2012, 20:04   #12
Active Member
 
Join Date: Sep 2010
Posts: 8,607


10903 likes received
1862 likes given
Default

Quote:
Originally Posted by hld12 View Post
What I usually do is total up the column and divide that number by however many readings I have. I have Microsoft Works spreadsheet, so I can't do all the things that Excel does.
If you've got a Hotmail account, you could use the Microsoft's document system on their cloud system to run an excel spreadsheet. (they allow you to use their copy )

However, as Miss_Blue said, getting clever with the statistical system doesn't really add a lot of useful information. Your own simple average figure, used as a guide will let you see a trend over time up or down without wasting a lot of time.

John.in.France is offline  
Old 07-05-2012, 20:27   #13
Senior Member
 
Miss_Blue's Avatar
 
Join Date: Apr 2009
Location: Chicago, IL
Posts: 561

Member Type
Type 2
Diagnosed in 2008

526 likes received
478 likes given
Default

Yeah, exactly. The SD would only give you an idea of your variation, which I suppose is useful. Of course, you can just run your finger down your individual readings and take note that way, but if you just really enjoy math...

Miss_Blue is offline  
 
Old 07-05-2012, 20:45   #14
Active Member
 
Join Date: Sep 2010
Posts: 8,607


10903 likes received
1862 likes given
Default

Quote:
Originally Posted by Miss_Blue View Post
Yeah, exactly. The SD would only give you an idea of your variation, which I suppose is useful. Of course, you can just run your finger down your individual readings and take note that way, but if you just really enjoy math...
Guilty as charged

I've got nearly two years worth of blood glucose and blood pressure readings along with carbohydrate intake, temperatures, my weight (that goes back five years) all in a very nice SQL database.

I can draw some very pretty pictures with it and my quack is most impressed with my monthly reports - but I suspect I could have coped with a simple notebook and a pencil! (but my handwriting is terrible)

John.in.France is offline  
Old 07-06-2012, 14:07   #15
Active Member
 
Join Date: Sep 2010
Posts: 8,607


10903 likes received
1862 likes given
Default

Quote:
Originally Posted by Miss_Blue View Post
Yeah, exactly. The SD would only give you an idea of your variation, which I suppose is useful. Of course, you can just run your finger down your individual readings and take note that way, but if you just really enjoy math...
You are a real trouble maker!

You got me thinking about standard deviations - so I worked mine out.

Over the last twelve months,
  • I've taken 366 fasting readings.
  • The average value was 84.14.
  • The standard deviation was 4.7.
  • So that means 346 of my readings fell in the range 74.74 to 93.55.
No-body can accuse me of being a control freak - Can they?

Miss_Blue and Shanny like this.
John.in.France is offline  
Old 07-06-2012, 14:48   #16
Senior Member
 
Join Date: Aug 2011
Location: Delhi, India
Posts: 1,444

Member Type
Type 2
Diagnosed in 2011

686 likes received
123 likes given
Default

Quote:
Originally Posted by John.in.France View Post
You are a real trouble maker!

You got me thinking about standard deviations - so I worked mine out.

Over the last twelve months,
  • I've taken 366 fasting readings.
  • The average value was 84.14.
  • The standard deviation was 4.7.
  • So that means 346 of my readings fell in the range 74.74 to 93.55.
No-body can accuse me of being a control freak - Can they?
been there, done that...





.

__________________

HbA1c 5.9 (Feb 2019)
Medication
Novarapid = 4-5 at breakfast (no other insulin)
Metformin 1000 mg

Lifesytle: LC, exercise most days


--------------------------------------------------------
"Be the change you want to see in the world" - Mahatma Gandhi
tony0611 is offline  
Old 07-06-2012, 18:01   #17
Senior Member
 
Miss_Blue's Avatar
 
Join Date: Apr 2009
Location: Chicago, IL
Posts: 561

Member Type
Type 2
Diagnosed in 2008

526 likes received
478 likes given
Default

Quote:
Originally Posted by John.in.France View Post
You are a real trouble maker!

You got me thinking about standard deviations - so I worked mine out.

Over the last twelve months,
  • I've taken 366 fasting readings.
  • The average value was 84.14.
  • The standard deviation was 4.7.
  • So that means 346 of my readings fell in the range 74.74 to 93.55.
No-body can accuse me of being a control freak - Can they?
That's what I would do, too, if I let myself, which is why I hardly ever bother recording my numbers anymore. One day at a time, one day at a time...

Miss_Blue is offline  
Old 07-07-2012, 08:58   #18
Senior Member
 
Join Date: Jun 2012
Posts: 50

Member Type
Type Undiagnosed
Diagnosed in NA

13 likes received
23 likes given
Default

Does any take a moving average (say a full weeks worth, adding a day and removing a day as you go along) ?

seems like a good way to smooth out odd peaks and let you see the longer trend...

madd0ct0r is offline  
Old 07-07-2012, 09:05   #19
Active Member
 
Join Date: Sep 2010
Posts: 8,607


10903 likes received
1862 likes given
Default

Quote:
Originally Posted by madd0ct0r View Post
Does any take a moving average (say a full weeks worth, adding a day and removing a day as you go along) ?

seems like a good way to smooth out odd peaks and let you see the longer trend...
Yep,

My monthly report does a rolling week (4 values) and a final monthly average. Not entirely sure that it gets looked at by the doctor.

On the other hand, since my figures are pretty stable, the moving average doesn't move much at all. I think it would be more useful for individuals who are just getting their numbers under control when the improving (hopefully) moving average might be encouraging.

John.in.France is offline  
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
inconsistent meter readings... beefy Diabetes 13 05-23-2012 20:26
Meter readings Evergrean New Member Introductions 2 09-05-2011 17:48
Need help with meter readings Seahawkfan02 New Member Introductions 4 03-31-2011 13:10
Question about meter readings... Wendys8861 Diabetes 7 12-04-2010 06:15
A1C & Meter Readings breezeonby Diabetes 1 03-06-2010 17:35

LEGAL NOTICE
By using this Website, you agree to abide by our Terms and Conditions (the "Terms"). This notice does not replace our Terms, which you must read in full as they contain important information. You must not post any defamatory, unlawful or undesirable content, or any content copied from a third party, on the Website. You must not copy material from the Website except in accordance with the Terms. This Website gives users an opportunity to share information only and is not intended to contain any advice which you should rely upon. It does not replace the need to take professional or other advice. We have no liability to you or any other person in respect of any content on this Website.


All times are GMT +1. The time now is 20:22.




Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.1.0 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.