Hi,
I need to take average of 4/8 unique random values out of a sample of 16 values, there are a no. of 4*4 grids. what can be the easiest way to get the random sample average other than assigning each value a random value from 1-16 and taking any 4.
I have attached a the data sample for reference. Random sample.xlsx
Bookmarks