text: how do you calculate the standard deviation of a weighted average? and if you could show me how to do it in ms excel, that would be evn better. take the average of the weighted average figures.then square the difference between this average and each wighted average numbers used in the calculation of average.calculate the average of these squared numbers.and-lastly take its square root.the result is the std devn of the weighted averages.