[Shel_B]

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

[MCS]

Do you have access to MS Excell?

[jps]

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.

[bunbury]

Originally Posted by jps

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.

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?

[Shel_B]

Originally Posted by MCS

Do you have access to MS Excell?

Nope. Why would I need Excel?

Shel

[morrisma]

Excel has SD and Variance function built in. It will also make pretty graphs.
Mike

[Lloyd]

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

[Richard157]

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.

[bunbury]

Originally Posted by Richard157

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.

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).

[Jonathan_R]

Originally Posted by morrisma

Excel has SD and Variance function built in. It will also make pretty graphs.
Mike

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.

[Richard157]

Standard Deviation Calculator