weighting data
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.
|