How To Calculate Standard Deviation ?

[#1]

hi

[swuehl]

You want to create a field with a constant value (the stddev of your other field values)?

You can do this using simple maths:

Standard deviation - Wikipedia, the free encyclopedia‌

But why don't you want to use the QV function?

edit:

If you want to create a field for the standard deviation, maybe like

A:

LOAD * INLINE [

Column A  

   1                            

   5                            

   6                            

   8                           

   15                          

];

JOIN LOAD

Stdev([Column A]) as STDEV

RESIDENT A;

[jagan]

Hi,

Check below from Qlikview Help file (F1)

For Front end

stdev([{set_expression}][ distinct ] [ total [<fld { , fld } >] ] expression)

Returns the aggregated standard deviation of expression or field iterated over the chart dimension(s).

This function has the same limitations for nested aggregation as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function. The stdev function supports Set Analysis and the total qualifier in the same way as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function.

Examples:

stdev(Sales)

stdev(X'Y/3)

stdev(distinct Price)

stdev(total Sales)

stdev({1} total Sales)

For Backend script

Returns the standard deviation of expression over a number of records as defined by a group by clause. If the word distinct occurs before the expression, all duplicates will be disregarded.

Example:

Load Month, stdev(Sales) as SalesStandardDeviation from abc.csv group by Month;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi,

Please go through this link:

Re: standard deviation (rangestdev) for my values