Sampling data

[BHoll]

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

[rwunderlich]

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

[BHoll]

Hi Rob,

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