Hi all,

I am trying to calculate the Standard Deviation of an array. However, to populate the array, I have the following:



Count Number 1 Count Number 2 Count Number 3
1 100 2 200 3 300

For example, this above means that there are 1 100's, 2 200's, 3 300's. I would ideally like to populate an array that is {100,200,200,300,300,300} based on those 6 columns that provide a count and a number. Then, I would like to calculate the standard deviation based on those (in this case it is 74.5).

Does anyone know how to do this without VBA? Thank you so so much! Any help / tips would be greatly appreciated...array.jpg