how can I show the current moving average value
I have dates in one column and numeric values in an adjacent column. The data is shown in a chart with a moving average (last 7 days) trend line but I want to do is show the current value of that moving average.
current moving average value
… of which values and how organized - In fact AVERAGE(A1:A10) in cell B10 copied down to B11, B12 and so on, provides a moving average value of the last 10 values. But your questions lacks all required details to provide a solution to your real task.
but I want to do is show the current value of that moving average.
Does this mean: I have a single cell showing average of “adjacent column” where column date is today, today-1, today-2…today-6 ?
Hello,
though I don’t fully understand, what you are really looking for, you may want to take a look into the following sample file: MovingAverage.ods, which uses formula:
=AVERAGE(OFFSET(B2;MATCH(E1-6;A2:A9999;0)-1;0;7;1)) in cell E3 to calculate the moving average of the last 7 values based on date given in cell E1.
Note(s):
C is only for checking purposes, it is not required for the formula to workC but uses chart trend line functionalityC as a data column for the chart.Hope that gives you an idea, how it could be done.
Many thanks - v helpful!