Standard Deviation

[Kathy]

Hi ,

Do you know the Function name to calculate Standard Deviation?

Thanks

[Lothar Haensler]

AFAIK VB does not have a builtin function for calculating the standard deviation.
You could use Excel's STDEV function via automation or use the code in MSDN article Q111727 to calculate the standard deviation yourself.

[czimmerman]

See http://www.freevbcode.com/ShowCode.ASP?ID=15 for code that calculates the standard deviation of elements in an array.

[Nparag]

Can you please elaborate on how do i use excel's standard deviation function through automation
I am also doing some mathematical model in which i need to calculate the standard deviation.

thanks