O'Reilly logo

Microsoft® Excel Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 50. Using Moving Averages to Understand Time Series

  • I’m trying to analyze the upward trend in quarterly revenues of toy sales since 1993. Fourth quarter sales are always larger (because of the Christmas holidays) than sales during the first quarter of the following year. This pattern obscures the upward trend in sales. Is there any way that I can graphically show the upward trend in revenues?

Time series data simply displays the same quantity measured at different points in time. For example, the worksheet named Data and Chart in the file Toysrusma.xls, shown in Figure 50-1, displays the time series for quarterly revenues in thousands of dollars. Our data covers the time interval from the first quarter of 1993 through the fourth quarter ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required