Please help- Finding seperate averages for spans of data
Apr 16, 2019 5:49 PM(1750 views)
Hi, I really need help trying to find seperate averages of data using a formula. I created a column that has a span of data, and I need to figure out the average of the data before that span starts (starting after the span before). I got an inverse span data column, but how can I seperate the data between spans to get an average for each section of data?
I tried to take the lag of up to five rows before the span starts, but it did not seem to work at all.
I can't exactly tell what you want, but I think this should work: if you can select the spans of rows you want to average over (just select them - or you can use a formula if it will identify the rows you want to span), then Under Row Selection Name Selection in column will create a column of 0 and 1 for the two groups of rows (or you can name them something else). Then, create a formula using the Column Mean function and use a By variable of the column you just created. This should give you the mean for each span of rows separately.