Question: how to calculate weighted average standard deviation in excel?
Answer: Remember that the formula for weighted mean is: ˉx∗=∑Ni=1wixi∑Ni=1wi. Use the appropriate weights to get the desired result. In your case I would suggest to use Number of cases in segmentTotal number of cases.