Standard Deviation

[tracycrown]

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

[shiveshsingh]

Please refer attached app

[swuehl]

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

=Stdev(X)

e.g. in a text box.

[shiveshsingh · Accepted solution]

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)

[MarcoWedel]

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

[tracycrown]

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. 

[tracycrown]

Dear Mr. Shivesh Singh

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

Best Regards

Tracy

[tracycrown]

Dear Mr. Stefan Wuhl

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

Best Regards

Tracy 

[shiveshsingh]

Glad to know it worked