topic Sampling data in QlikView

Sampling data

BHoll — Wed, 12 Jun 2019 12:57:05 GMT

Hello everyone,

i Need a solution for the following Problem:

I have four products A,B,C,D. Every product has a value from 0 to 1. I want to create a line Diagramm where every point in the diagramm represents the average value of a random n-size -sample from the value.

For example i chose n = 5. Now the first point in the diagramm should be the average of 5 random values out of all values in my dataset. When i select a certain product, the first point in the diagramm should be the average of a 5 size random sample from the selected product.

Feel free to check out my sample file.

Best regards,

smbeholl

Re: Sampling data

rwunderlich — Wed, 12 Jun 2019 20:11:42 GMT

How close to true random does it need to be? If I select n=5 for the same set of data at two different points in time, is it acceptable that I get the same results? Or are you expecting different results each time you select the same n value?

-Rob

Re: Sampling data

BHoll — Fri, 28 Jun 2019 13:55:35 GMT

Hi Rob,

it would be sufficient if i get the same data points for the same n every time.