Calculate Standard Deviation of portion of Array
Posted on 2011-10-18
I have a 3 column array that say is around 100 elements long.
I'm trying to using the worksheet.function to calculate the STDDEV, but only of a piece of the array.
FYI, doing all this in VBA
'stddevArray(3, a) = application.WorksheetFunction.StDev("item1 in array:item2 in array")
I understand the parameter has to be the range of stddev. Anyone know the quick and easy code for starting point and ending point in the array?