Rolling Averages in Excel?
May 21, 2006 8:51 AM Subscribe
Excelfilter: how do I compute a rolling seven-day average for something that happens at sporadic intervals?
posted by jessamyn to Computers & Internet (21 answers total)
I keep an exercise log and I'd like to have both entries for how much I'm swimming as well as how much swimming I've done in the preceding seven days [not like a Sunday to Saturday week, just the last seven days] and how it compares to previous seven day increments. I swim four out of seven days on no particular schedule. My spreadsheet, such as it is, looks like this, with about seven months of data.
I've got a chart with daily values over time and a trendline. I'd really like to be able to figure out how to make a chart with just seven day averages, but I'm not sure how to go about it. Most of the examples I've seen are for things where there are regular data elements that need to be dealt with, like daily revenues. I'm good with spreadsheets in general, but not super smart with functions so the more explanation the better where functions are involved. Thanks.