STDEV.S function in qlikview

[#1]

Hi

Does someone know if QV has a function that similar to the STDEV.S function in excel? (the function calculates the sample standard deviation of a supplied set of values).

Thanks

[swuehl]

I believe the QV stdev() function works like STDEV.S in Excel.

For large sample sizes, both Excel functions (STDEV.S and STDEV.P) converge.

You can transform Stdev.S into Stdev.P by calculating something like

Stdev.S * sqrt(N-1) / sqrt(N)  = Stdev.P

or

Stdev.S = sqrt(N) /sqrt(N-1) * Stdev.P

N being your sample size (count of values).

[#3]

Hi thanks for answering.

lets say I have "store name" as dimension and I have 5 expressions: week1,week2,week3,week4 (each expression count the number of activities per store in different week number). The last expression is an average of all 4 weeks.

I want to calculate the "stdev()" of week1,week2,week3,week4 values. how can I do that?

hope I was clear enough, thank you

[swuehl]

If I understood correctly, basically replace avg() function with stdev().

If you need more help, please post a small sample or post the expression definitions.

[#5]

Hi

sorry for the delay and thanks for answering.

If you can, please check the attached file. hope it was enough.

thank you

[swuehl · Accepted solution]

Your sample file shows zeros for all expression.

But I think you can try using RangeStdev() function:

=RangeStdev(T1, T2, T3, T4)

[#7]

Thank you so much! it worked!