I have a problem where I essentially need to know when the variance of a data set "evens out" as you take random samples. I have a column of data points (column A). I want to create a variance column (B) where each cell selects X number of cells from column A randomly, then computes the variance of those cells. The next cell in column B would select X+1 cells from column A and display the variance, and so on. Is there a way to easily do this?

Thank you!