Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weighting data
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reconciliation of Data With Two Conditions | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |