Hello!
I'm trying to get the standard deviation of the values in a one dimentional
array.
Excel obviously has the function, but the necesary argument is a range.
I was thinking of calculating the st.dev manually, but that not very cool.
Is there a way of using the items in an array as the arguments for the
Standard Deviation Worksheet.Function?
Thanks in advance,
Albert C

When called from VBA you can pass it an array:

Sub Test()
Dim A As Variant
A = Array(1, 2, 1, 4, 2, 3)
MsgBox Application.WorksheetFunction.StDev(A)
End Sub

(or StDevP(A) as the case may be)

Hope this helps

-John Coleman

Albert wrote:
Hello!
I'm trying to get the standard deviation of the values in a one dimentional
array.
Excel obviously has the function, but the necesary argument is a range.
I was thinking of calculating the st.dev manually, but that not very cool.
Is there a way of using the items in an array as the arguments for the
Standard Deviation Worksheet.Function?
Thanks in advance,
Albert C

This worked ok for me:


Albert wrote:

Hello!
I'm trying to get the standard deviation of the values in a one dimentional
array.
Excel obviously has the function, but the necesary argument is a range.
I was thinking of calculating the st.dev manually, but that not very cool.
Is there a way of using the items in an array as the arguments for the
Standard Deviation Worksheet.Function?
Thanks in advance,
Albert C

--

Dave Peterson

This (still) worked ok for me:

Option Explicit
Sub testme01()
Dim myArr As Variant
myArr = Array(1, 2, 3, 4, 5)
MsgBox Application.StDev(myArr)
End Sub


I could use this, too:
MsgBox Application.WorksheetFunction.StDev(myArr)

Albert wrote:

Hello!
I'm trying to get the standard deviation of the values in a one dimentional
array.
Excel obviously has the function, but the necesary argument is a range.
I was thinking of calculating the st.dev manually, but that not very cool.
Is there a way of using the items in an array as the arguments for the
Standard Deviation Worksheet.Function?
Thanks in advance,
Albert C

--

Dave Peterson

Thank you sir,
Worked Great.

"Dave Peterson" wrote:

This (still) worked ok for me:

Option Explicit
Sub testme01()
Dim myArr As Variant
myArr = Array(1, 2, 3, 4, 5)
MsgBox Application.StDev(myArr)
End Sub


I could use this, too:
MsgBox Application.WorksheetFunction.StDev(myArr)

Albert wrote:

Hello!
I'm trying to get the standard deviation of the values in a one dimentional
array.
Excel obviously has the function, but the necesary argument is a range.
I was thinking of calculating the st.dev manually, but that not very cool.
Is there a way of using the items in an array as the arguments for the
Standard Deviation Worksheet.Function?
Thanks in advance,
Albert C

--

Dave Peterson