Hi guys,
I have been trying to calculate the weighted standard deviation for some data series but do not seem to get it right - the result is apparently somewhat off the mark. It would be really great if I could get some help on this - I have attached a spreadsheet that, the result in the red column is mine and the one in the green is the one that should be matched, I guess it was calculated in Crystal Ball or something like that, the yellow column is for the would be new formula).
Many thanks.
David
I have been trying to calculate the weighted standard deviation for some data series but do not seem to get it right - the result is apparently somewhat off the mark. It would be really great if I could get some help on this - I have attached a spreadsheet that, the result in the red column is mine and the one in the green is the one that should be matched, I guess it was calculated in Crystal Ball or something like that, the yellow column is for the would be new formula).
Many thanks.
David