Chapter 62. Using moving averages to understand time series
Question answered in this chapter:
I’m trying to analyze the upward trend in quarterly revenues of Amazon.com since 1996. Fourth quarter sales in the United States are usually larger (because of Christmas) than sales during the first quarter of the following year. This pattern obscures the upward trend in sales. How can I show the upward trend in revenues graphically?
Answer to this chapter’s question
This section provides the answer to the question that is listed at the beginning of the chapter.
Time series data simply displays the same quantity measured at different points in time. For example, the data in the Amazon.com.xlsx file, a subset of which is shown in Figure 62-1, displays the ...
Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
