I have an array arrData(800,15). I want to find the standard deviation of the data in arrData(800,10). Is there a way to do this without entering 800 rows in an excel spreadsheet and using STDEV.S there? Thanks.
I have an array arrData(800,15). I want to find the standard deviation of the data in arrData(800,10). Is there a way to do this without entering 800 rows in an excel spreadsheet and using STDEV.S there? Thanks.
have you seen this:
VBA: Multidimentional Array Syntax for STDEV Evaluation | MrExcel Message Board
sd = Application.StDev_S(Application.Index(arrData, ,10))
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote
