About using the function formula in Excel (STDev ())

 

Sometimes some EXCEL function formulas are used for development. You can use the following method to call the function operation in Excel and then return the value.

'Dbldata is the data group required for calculation.

'Stdev standard deviation formula

Public Function calculatestandarddevition (byval dbldata as decimal () as decimal dim XL as new excel. application dim s as string = "" dim datavalue as Decimal for NX as integer = 0 to dbldata. length-1 If NX + 1 = dbldata. length then S + = dbldata (nx ). tostring () else S + = dbldata (nx ). tostring () + "," end if next S = "STDev (" + S + ")" datavalue = ctype (XL. evaluate (s), decimal) XL = nothing return datavalue end Function