volabos
08-12-2014, 11:28 AM
Hi again,
I am getting trouble to use Excel's stdev() function in VBA. If I use that function in VBA, the result is not matching with what we get if I use in Excel-sheet.
I am attaching my workout file. I created asd() sub where I use stdev() function. Also calculated standard-deviation in excel-sheet itself. There is mis-match. Can somebody help me out to understand why I am getting the difference?
Thanks for your help.
Regards,
I am getting trouble to use Excel's stdev() function in VBA. If I use that function in VBA, the result is not matching with what we get if I use in Excel-sheet.
I am attaching my workout file. I created asd() sub where I use stdev() function. Also calculated standard-deviation in excel-sheet itself. There is mis-match. Can somebody help me out to understand why I am getting the difference?
Thanks for your help.
Regards,