Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to calculate a single weighed average (a "Response Index") from three email disposition metrics:
The averages for all campaigns (and thus "Response Index" = 100): Open Rate 26.3% (a number higher than this is better) Click Rate 3.4% (a number higher than this is better) Unsubscribe Rate 0.02% (a number LOWER than this is better) I would like the "Response Index" to represent these weights: 45% Open Rate 45% Click Rate 10% Unsubscribe Rate Sample Campaign #1: Open Rate 20.1% Click Rate 4.1% Unsubscribe Rate 0.00% How would I calculate the Response Index for Sample Campaign 1? This does not work: 20.1%/26.3%*45 + 4.1%/3.4%*45 + 0.00%/0.02%*10 Thanks for your help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weighted Average | Excel Discussion (Misc queries) | |||
Calculating a weighted average in a pivot table | Excel Discussion (Misc queries) | |||
weighted average | Excel Discussion (Misc queries) | |||
calculating a weighted average using formula | Excel Worksheet Functions | |||
calculating a weighted average uisng formula | Excel Worksheet Functions |