topic Standard Deviation in QlikView

Standard Deviation

Wed, 25 Nov 2020 16:16:04 GMT

I am working on finding the standard deviation for a list of times from purchased to delivery. I followed the examples in other feeds but I need clarification.

Basically I subtracted the purchased time from the delivered and came up with a new list of time labeled purchasetodeliv.

I created a set analysis for this but unsure if it is correct or not.

Stdev({$< [Status Code]={'Black Shirts'}>}purchasetodeliv)

purchasetodeliv (in hours)

60.5

70.7

19.3

230.1

145

555.6

26.7

Re: Standard Deviation

sunny_talwar — Wed, 02 Aug 2017 19:46:27 GMT

Syntax looks right to me... is there anything wrong with the output you get?

Re: Standard Deviation

Wed, 02 Aug 2017 19:56:03 GMT

Its just that the deviation looks high so I was not sure if I was doing the right thing.

Thanks for the clarification.

Re: Standard Deviation

ankur_abhishek — Thu, 03 Aug 2017 03:29:33 GMT

Hi Kurleigh,

Formula is correct it stddev should come around 190.20. Refer the below screenshot for reference . It is derived from using your data set values