Chapter 56
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 1995. 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. Is there any way that I can graphically show the upward trend in revenues?
Answer to this chapter’s question
I’m trying to analyze the upward trend in quarterly revenues of Amazon.com since 1995. 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 ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition 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.
