Join Curt Frye for an in-depth discussion in this video Calculating running averages, part of Learning Excel Data-Analysis.
- 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…
Author
Released
3/28/2015Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Calculating mean and median values
- Analyzing data using variance and standard deviation
- Minimizing errors
- Visualizing data with histograms, charts, and more
- Testing hypotheses
- Measuring covariance and correlation
- Performing Bayesian analysis
Skill Level Beginner
Duration
Views
Related Courses
-
Learning Excel Cluster Analysis
with Curt Frye1h 9m Advanced -
Excel Data Analysis: Forecasting
with Wayne Winston3h 7m Intermediate
-
Introduction
-
Welcome59s
-
What you should know1m 29s
-
-
1. Foundational Concepts of Data Analysis
-
2. Visualizing Data
-
Forecasting future results5m 24s
-
Calculating running averages5m 19s
-
3. Testing a Hypothesis
-
Formulating a hypothesis3m 51s
-
-
4. Utilizing Data Distributions
-
Using a uniform distribution6m 21s
-
5. Measuring Covariance and Correlation
-
6. Performing Bayesian Analysis
-
Conclusion
-
Further resources2m 4s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Calculating running averages