Calculating running averages

- Collecting data over time allows you…to perform many kinds of analysis.…One useful way to analyze your data…is to find the average.…For example, you might have a count…of the number of customers who've come to your store…or website over the course of a year…and by calculating an average…you can find the number of customers…who typically come to your store or site…during a month.…What I'll do in this movie is to show you…how to calculate running averages…that only look at data…from a certain number of months…in your collection.…

My sample file is the running average workbook…and you can find it in the Chapter 02 folder…of your Exercise Files collection.…This workbook contains monthly customer data…for January through December in a year…and what I'd like to do is to calculate a running average…and by that I mean I want…to calculate the average for January…which would just be January value…'cause there's only one month…but then in the 2nd row of the Running Average column…I'd like to have the average for January and February…