Standard Deviation VBA code

[loganblacke]

Hey everyone. I need help with the vba code to calculate the standard deviation for any number of values entered into column A. I already have the code for number of values, sum, and average. Having trouble with the standard deviation. Workbook is attached, thanks!

I forgot to mention that I can't use the excel functions in my code. Thanks!

[Paul]

Hi Logan, welcome to the forum.

Yes, you can use Excel functions in your code. It's quite standard practice, actually. Unless, of course, this is a homework assignment and you've been instructed not to. In which case, using VBA to do math is as easy as assigning variables, performing math on those variables, and getting a result.

Use your knowledge of how to calculate a standard deviation by hand, then convert that information to formulas.

Since you already have code to get the other values, I thought I'd at least help provide more efficient code to get the results without using Excel worksheet functions.

Please Login or Register  to view this content.