Hi,

I am trying to create a spreadsheet to calculate X-Bar-Bar from a column of data DEPENDING on the subgroup size selected by the user. Xbar-bar is a "mean" of a group of "means".

More precisely, this is what I wanted to achieve...

I have a column of data
User selects a whole number from 1 to 10
The data in the columns is grouped by the whole number. (not actually physically grouped, just mathematically for calculation purposes - in consecutive order in the column)
A an average for each group is calculated.
Then finally, the average of THOSE averages is stored in a cell.

See image:
https://ibb.co/eG6yHQ


This will require some VBA code but I am inexperienced and perhaps there is another solution. I can manipulate the code to get it how I want it for the specific columns and such. I just need to be able to do this.


Thanks for any help.