Standard Deviation

Hi ,

Do you know the Function name to calculate Standard Deviation?

Thanks

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.

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

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