Generate n sample with a certain level of confidence

Wow, that's great. Thanks Bernie.

I've used your function in my example and looks great. It is exactly what I wanted.

I was wondering also, if it's possible to create seasonal samples.

For example if Sample (n) is equal 20 then we have 18 "seasons" in a year (so we will generate 18 times samples of 20). If Sample (n) is equal 30 then we have 12 "seasons" in a year (so we will generate 12 times samples of 30).

As and example, if we have a Sample (n) of 7 we will have 52 "seasons". 1 to 7, 8 to 14, 15 to 21, etc... until 359 to 365

Day Value
1 129
2 109
3 121
4 138
5 130
6 140
7 137
8 102
9 103
10 109
11 105
12 100
13 101
14 111
....
365

I've attached the document

Random values.xlsx

Thanks in advance!