I am try to calculate the rolling 365 day average.
So that would imply there are 365 values.
2007-02-09 04:07:36 · 3 answers · asked by Guess 3 in Business & Finance ➔ Other - Business & Finance
Assuming that the data will be filled into cells A2 through A366, you can use this formula: =sum(A2:A366)/count(A2:A366)
if all of the data is already filled in, then you can use this formula: =average(A2:A366)
2007-02-09 04:16:13 · answer #1 · answered by Dale 2 · 0⤊ 0⤋
If you have 365 values, simply go to where you want the average to be posted, enter "=", go to your Function (x) or [f(x)] and click on average. Finally scan over all your data you want to find the average for. Hit enter...and poof...there's your average.
2007-02-09 12:13:27 · answer #2 · answered by Anonymous · 0⤊ 0⤋
You will need to have a year of prior data to start your moving average. Try to use smaller intervals to show seasonal trends. Otherwise use a simple trendline instead. Do it directly with charts. Right click the data, add-trendlines example below
2007-02-09 13:34:57 · answer #3 · answered by unnga 6 · 0⤊ 0⤋