R
RobcPettit
Hi Im trying to figure out why:
Dim j As Variant, x As Variant, k as variant
Dim arr(15) As Single
For x = 1 To 15
arr(j) = 5
j = j + 1
Next x
j = Application.WorksheetFunction.Average(arr)
k = Application.WorksheetFunction.StDev(arr),
does not return the expected results of 5 and 0. I get 4.68 and 1.25.
Any Ideas. Regards Robert
Dim j As Variant, x As Variant, k as variant
Dim arr(15) As Single
For x = 1 To 15
arr(j) = 5
j = j + 1
Next x
j = Application.WorksheetFunction.Average(arr)
k = Application.WorksheetFunction.StDev(arr),
does not return the expected results of 5 and 0. I get 4.68 and 1.25.
Any Ideas. Regards Robert