ExcelBanter - weighting data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - weighting data (https://www.excelbanter.com/excel-worksheet-functions/128605-weighting-data.html)

Without using VBA is there a way to give more recent data events and future
events a heavier weight in an equation than events that happened longer ago?
e.g.
data score for 1/30 - 80
1/3 1- 90
2/1 - 100
2/2 - 90
2/3 - 80
2/4 - 70
So that time sensitive data would influence the outcome of an equation.

Even without VBA if A1 thru A6 contain:

80
90
100
90
80
70

then

=(A1*1+A2*2+A3*3+A4*4+A5*5+A6*6)/(1+2+3+4+5+6)

is one type of weighted average. The actual weights are sort of arbitrary,
just note the division by the sum of the weights.
--
Gary's Student
gsnu200703

"mmcap" wrote:

Without using VBA is there a way to give more recent data events and future
events a heavier weight in an equation than events that happened longer ago?
e.g.
data score for 1/30 - 80
1/3 1- 90
2/1 - 100
2/2 - 90
2/3 - 80
2/4 - 70
So that time sensitive data would influence the outcome of an equation.