1

Let's say I have sales number of last 60 days. I can just draw a graph to see how sales has changed overtime. Numbers vary in different days, like on weekends sales numbers decrease.

However, I would like to get sum of every last X days of everyday. So that I can have more idea and better distributed number of sales.

For example my graph will include

  • Sum of Day - 60 to 30
  • Sum of Day - 59 to 29
  • Sum of Day - 58 to 28
  • Sum of Day - 57 to 27

......

  • Sum of Day - 33 to 3
  • Sum of Day - 32 to 2
  • Sum of Day - 31 to 1

I am wondering what this is called technically and theoretically(recursive, iterative, culumative )? What type of graph can I use for it

Also it would be great if you can give an example if there is an example of excel for this.

SNaRe
  • 111
  • 1
  • 1
    The general topic is 'moving average'. [In R](https://www.rdocumentation.org/packages/pracma/versions/1.9.9/topics/movavg). – BruceET Jan 12 '19 at 20:10
  • Thank you. This is the answer that I was looking for. If you can create an answer, I can approve it. – SNaRe Jan 13 '19 at 07:45
  • 1
    Glad my comment was helpful. For this brief item, I'm happy to take your thanks in lieu of reputation points. And maybe someone knows how to do it in Excel. – BruceET Jan 13 '19 at 07:57

0 Answers0