Do you have access to MS Excell?
This is a discussion on Standard Deviation within the Type 2 Diabetes forums, part of the Diabetes category; Hi Gang ... Since signing back on I've seen "standard deviation" mentioned several times. While I understand what it is, ...
Hi Gang ...
Since signing back on I've seen "standard deviation" mentioned several times. While I understand what it is, how does one measure it at home?
Thanks for any advice/suggestions.
Shel
Do you have access to MS Excell?
---------------------------------
Bitter Melon, Vanadyl Sulfate
Chromium Pichnolate, Gymnema Sylvestre
Amino Acids, Vitamins Bx, C, D, E
Hi-Maize 260, Ground and Whole Flax Seed
COQ10, Magnesium, Zinc, Selenium, Fish Oil
Alpha-Lipoic-Acid, Biotin, ACAI Berry
Beta Blocker, Statin, not taking at this time, Lisinopril
A1C estimate of 10-12 at dxed 5.6, 4.8, ??
When asked do you eat low carb, I respond, I eat complex carbs, the ones that are manageable in regards to my BG levels.
You can use XL, you can use any mathematical calculator, or I am sure there are a ton of standard deviation calculators online to use. Just plug in your glucose values. It will give you the mean and sample standard deviation.
Let's say you plug in several glucose values from the past ten days and your average glucose is 100 and the calculated sample standard deviation is 10... what that means is that about 68% of your glucose values are from 90-110 (one standard deviation on each side of the mean, 100-10 to 100 + 10). Two standard deviations means that 95% of the time, your values are between 80 and 120. Three standard deviations means that 99.5% of the time, you are between 70 and 130.
The smaller the standard deviation, the less peaks and valleys. That's what you are aiming for.
I don't track it anymore, but when I was **** bent on gaining control, I had a three month average glucose of 88 with a standard deviation of just under 5, which is very, very tight control.
Standard deviation just completes the picture that an A1c partially paints.
"That which doesn't kill us makes us stronger" - Friedrich Nietzsche
I used to do it too and was typically around 5. I stopped when I bought a OneTouch Ultra Smart meter that tracks everything else I need except Standard Deviation - and I gave up spread sheets. I have a better feel for the range of my numbers now, but it's a good figure to have.
So OneTouch, how about adding SD to a meter please?
Excel has SD and Variance function built in. It will also make pretty graphs.
Mike
Type 1 since '88
Pumping since 2002
Some meters and software that you upload meters to have it, like co-pilot.
Some pumps, and software you upload pump data to have it also.
-Lloyd
If it is to be, it's up to me!
http://www.forecast.diabetes.org/mag...atures/success
Insulin Dependent T2, C-peptide 0.2, D 16 years,
9/26/10 5.3 5/18/10 5.3 3/18/10 5.4 1/19/10 5.4 10/28/09 5.4 7/20/09 5.4 4/20/09 5.3 1/20/09 A1c 5.2 12/2/08 A1c 5.0 10/6/08 A1c 5.1 8/11/08 A1c 5.2 5/12/08 A1c 4.9 2/18/08 A1c 4.9 11/2007 A1c 5.3 8/2007 A1c 5.5 6/2007 A1c 5.7 3/2007 A1c 6.9 12/2006 A1c 7.8 9/2006 A1c 8.5 6/2006 A1c 8.7
Here is a standard deviation calculator I sure would not want to have to sit and enter all my tests for a yhree month period. That would be a pain! It does work though.
Type 1 for 64 years, no complications, A1c = 5.4, pump with MM 522, use Dexcom CGM
My ISBN number for placing orders for my book at bookstores is: 1450515967
See my profile for buying my book online.
OK, this thread has inspired me to up-load my meter to my computer. Since October 1st 2008 (the last time I did it) I have a Standard Deviation of .6 with an average BG reading of 5.2 (94 in the US) on an average of 6 tests a day.
If I understand it correctly, that puts my SD in the range of 86-106 (US).
So does openoffice.org, and openoffice.org is free.
Here is a screenshot of my diabetes log, or part of it. Note that I have standard deviation, and linear regression (the red line).
I can even save the spreadsheet as an Excel file, so that MS Excel can open it. In fact I have done that before.
So, why spend hoever much on MS Office, when you can get openoffice.org for free. openoffice.org is made by Sun Microsystems. You know, the people that make Java.
A1C 9.2
Type 1 for 64 years, no complications, A1c = 5.4, pump with MM 522, use Dexcom CGM
My ISBN number for placing orders for my book at bookstores is: 1450515967
See my profile for buying my book online.