How can I create a column for the statistics (means,max,min) of specific lots (specific rows) that I have in my data table?
I am able to create Mean or min or max of the whole column by clicking column properties, formula, statistical, Col Mean. This brings me the mean of the whole data set. How can I make it bring me the mean of every lot? for example, rows 1 to 10 are lot A, and rows 11 to 20 are lot B. I would like rows 1 to 10 to show me mean of Lot A and 11 to 20 to show me the mean of lot B.