In one new function in my vba code I have declared array variable and then used a procedure to fill it.
Dim arrROAA(0 To 4) As Double
'procedure to fill the array.
now I want to calculate the sample standard deviation . There is a function DStDev, but I have no idea how to apply this function to the data inside my array.
I tried:
stdev = DStDev(arrROAA(0), arrROAA(1), arrROAA(2), arrROAA(3), arrROAA(4))
But it didnot work.
Any help?