By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,327 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,327 IT Pros & Developers. It's quick & easy.

Calculating Standard Deviation?

P: n/a
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!
Apr 1 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Scott" <sc***@scott.scott> 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
Apr 2 '06 #2

P: n/a
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******@bellsouth.net> wrote in message
news:W2****************@bignews7.bellsouth.net...

"Scott" <sc***@scott.scott> 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

Apr 2 '06 #3

P: n/a
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.Application
Dim S As String = "Average(1, 2, 3, 4, 5, 6, 7, 8)"
MsgBox(xL.Evaluate(S).ToString)
S = "STDEV(1,2,3,4,5,6,7,8)"
MsgBox(xL.Evaluate(S).ToString)
"Scott" <sc***@scott.scott> 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!

Apr 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.