ridgeroad1
New Member
- Joined
- Mar 22, 2014
- Messages
- 1
Hello,
This is part of my data set on my fuel spending which I am trying to analyse:
<tbody>
</tbody>
To make sense of this data it would seem that a 14 or 28 Day moving average would be useful. I have tried charting this in Excel but it seems that Excel wants to give me the period moving average which means that if I spend 3 x $50 on fuel in march and 1 x $50 of fuel in February that the average stays the same when I have in fact spent far more in March.
Any help would be greatly appreciated.
Thanks,
Daniel
This is part of my data set on my fuel spending which I am trying to analyse:
23/02/2013 | $53.88 |
3/03/2013 | $47.80 |
16/03/2013 | $53.16 |
20/03/2013 | $87.81 |
3/04/2013 | $31.88 |
4/04/2013 | $79.28 |
17/04/2013 | $43.41 |
23/04/2013 | $70.37 |
2/05/2013 | $68.39 |
23/05/2013 | $84.36 |
26/05/2013 | $48.16 |
20/06/2013 | $75.87 |
22/06/2013 | $45.74 |
<tbody>
</tbody>
To make sense of this data it would seem that a 14 or 28 Day moving average would be useful. I have tried charting this in Excel but it seems that Excel wants to give me the period moving average which means that if I spend 3 x $50 on fuel in march and 1 x $50 of fuel in February that the average stays the same when I have in fact spent far more in March.
Any help would be greatly appreciated.
Thanks,
Daniel