Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Rob,
it would be sufficient if i get the same data points for the same n every time.