Weighted standard deviation

Tue, 04 Dec 2012 21:52:47 GMT

Hi everybody,

I really need help in Set analysis for calculating weighted standard deviation.

The regular standard deviation formula is here:

Stdev({$<X.QID = {$(=only(X_LIST.QID))}, Y.QID = {$(=only(Y_LIST.QID))}, %RESPONDENT = {">0"}>} Y.Answer)

To calculate the weighted one I need to have a formula like:

SQRT(Sum({$<X.QID = {$(=only(X_LIST.QID))}, Y.QID = {$(=only(Y_LIST.QID))}, %RESPONDENT = {">0"}>} SQR(WEIGHT*Y.Answer-MEANW))/

Count(({$<X.QID = {$(=only(X_LIST.QID))}, Y.QID = {$(=only(Y_LIST.QID))}, %RESPONDENT = {">0"}>} Y.Answer))

The MEANW - weighted average that was calculated before, but I don't know how to implement it into the set analysis. And if I calculate the MEANW in the STDEV formula, I don't get any results.

Please help!

Thank you very much in advance!

Re: Weighted standard deviation

Wed, 05 Dec 2012 19:17:42 GMT

Have you tried using the object Statistics Box?

Re: Weighted standard deviation

Thu, 06 Dec 2012 15:17:14 GMT

Thank you for your reply. Unfortunately, I did not find a way to use the Statistics Box in my case (couldn't set expressions in there).

topic Weighted standard deviation in QlikView

Weighted standard deviation

Re: Weighted standard deviation

Re: Weighted standard deviation