1. ## Weighted Average Problem

 Campaign Name List 1 List 2 List 3 Totals Targeted Dials 500 4000 1000 5500 % of Total 0.09 0.73 0.18 1.00 Targeted Conversion 3.00% 2.00% 7.50% 3.09% Targeted ASP $275.00$200.00 $375.00$238.64 Expected Revenue $4,125.00$16,000.00 $28,125.00$40,568.18

6. ## Re: Weighted Average Problem

And I figured it out Correct forumla should read

275(.08824) + 200(.47059) + 375(.44117) = 283.8225

Thanks Wilmer!

7. ## Re: Weighted Average Problem

YES. Sorry, used wrong line...I edited correction.

8. ## Re: Weighted Average Problem

Code:
Campaign Name            List 1         List 2        List 3        Totals
Targeted Dials              500           4000          1000          5500
Targeted Conversion         .03            .02          .075         .0309  [1]
---            ---          ----         -----
Converted                    15             80            75           170
Targeted ASP            $275.00$200.00       $375.00$283.82 [2]
Expected Revenue      $4,125.00$16,000.00    $28,125.00$48,250.00
Btw, I was showing the "individual converted percentages" to illustrate the breakdown.
But that's not really required in your Excel program: the "Totals column" can be "defaulted":

[1] (15+80+75) / 5500 = 170 / 5500 = .0309

[2] (4125 + 16000 + 28125) / 170 = 48250 / 170 = 283.82