topic Re: Standard Deviation in QlikView

Standard Deviation

tracycrown — Wed, 25 Nov 2020 16:16:04 GMT

Dear Sir/Madam

Can someone help to advise how to compute column 3 (X-Mean), column 4 (X-Mean)^2 and standard deviation ?.

The answer is as follows:

Student	X	X-Mean	(X- Mean)^2	Standard Deviation
A	65.0	-7.33	53.8
B	60.0	-12.33	152.1
C	70.0	-2.33	5.4
D	83.0	10.67	113.8
E	56.0	-16.33	266.8
F	100.0	27.67	765.4
Total	434.0	0.0	1,357.3

Mean	72.3
Standard Deviation		16.5

Thank You

Tracy

Re: Standard Deviation

shiveshsingh — Sun, 18 Mar 2018 05:35:50 GMT

Please refer attached app

Re: Standard Deviation

swuehl — Sun, 18 Mar 2018 11:17:32 GMT

The standard deviation can just be calculated using Stdev() function:

=Stdev(X)

e.g. in a text box.

Re: Standard Deviation

shiveshsingh — Sun, 18 Mar 2018 11:23:39 GMT

Expression for your SD, put this in last column

pow(sum(TOTAL (aggr(pow(sum(X)-sum(TOTAL(X))/count(TOTAL(Student)),2),Student)))/5,0.5)

Re: Standard Deviation

MarcoWedel — Sun, 18 Mar 2018 18:13:27 GMT

Hi,

you could also use the straight table in-built total mode or a statistics box to calculate the StDev:

hope this helps

regards

Marco

Re: Standard Deviation

tracycrown — Tue, 20 Mar 2018 15:52:45 GMT

Dear Mr Macro Wedel

You have enlightened me a new way to get the answers by using Statistical Function in Qlikview which I have not used it before, thank you very much.

Also, many thanks for your full support.

Best Regards

Tracy.

Re: Standard Deviation

tracycrown — Tue, 20 Mar 2018 15:55:15 GMT

Dear Mr. Shivesh Singh

Thank you for your quick advice, I have learned from you how to use the pow command.

Best Regards

Tracy

Re: Standard Deviation

tracycrown — Tue, 20 Mar 2018 15:56:49 GMT

Dear Mr. Stefan Wuhl

Thank you for teaching me a new command to compute standard deviation easily.

Best Regards

Tracy

Re: Standard Deviation

shiveshsingh — Tue, 20 Mar 2018 16:18:58 GMT

Glad to know it worked