Calculating Standard Deviation?

[Scott]

I know in some other languages there is a simple standard deviation function
(sdev(1,2,3,4,5 ,etc...)). But I'm unable to find a suitable alternative for
vb.net

I'm assuming it's there somewhere. Can someone tell me the how to call
standard deviation? I have a datatable and I need to determine the std for
a series of rows.

Thanks for the help!

[Hal Rosser]

"Scott" <sc***@scott.sc ott> wrote in message
news:rK******** *************** *******@comcast .com...

I know in some other languages there is a simple standard deviation function (sdev(1,2,3,4,5 ,etc...)). But I'm unable to find a suitable alternative for vb.net

I'm assuming it's there somewhere. Can someone tell me the how to call
standard deviation? I have a datatable and I need to determine the std for a series of rows.

The data is in a database - so you can use SQL to get that information.
http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html

[Scott]

Not quite. It's a datatable, not a database table.

I ended up just writing a function to do it. Annoying to have to do, but
not difficult.

"Hal Rosser" <hm******@bells outh.net> wrote in message
news:W2******** ********@bignew s7.bellsouth.ne t...

"Scott" <sc***@scott.sc ott> wrote in message
news:rK******** *************** *******@comcast .com...

I know in some other languages there is a simple standard deviation

function

(sdev(1,2,3,4,5 ,etc...)). But I'm unable to find a suitable alternative

for

vb.net

I'm assuming it's there somewhere. Can someone tell me the how to call
standard deviation? I have a datatable and I need to determine the std

for

a series of rows.

The data is in a database - so you can use SQL to get that information.
http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html

[William LaMartin]

You will either have to write your own function, which isn't hard, or you
can add a reference to Microsoft Excel and use the following type of code to
display both the average and standard deviation of a collection of numbers.

I would write my own function.

Dim xL As New Excel.Applicati on
Dim S As String = "Average(1, 2, 3, 4, 5, 6, 7, 8)"
MsgBox(xL.Evalu ate(S).ToString )
S = "STDEV(1,2,3,4, 5,6,7,8)"
MsgBox(xL.Evalu ate(S).ToString )
"Scott" <sc***@scott.sc ott> wrote in message
news:rK******** *************** *******@comcast .com...

I know in some other languages there is a simple standard deviation
function (sdev(1,2,3,4,5 ,etc...)). But I'm unable to find a suitable
alternative for vb.net

I'm assuming it's there somewhere. Can someone tell me the how to call
standard deviation? I have a datatable and I need to determine the std
for a series of rows.

Thanks for the help!