Weighted Average with CTR

[degross77]

Hi, I am trying to figure out a Weighted Average with two variables and a percentage.
Here is what I am trying to do:
I had 3 samples, that had impressions and Clicks, and the CTR equals clicks/impressions. How do I get a wedighted average from here?

Please Login or Register  to view this content.

[shg]

Weighted average of what -- what are you trying to calculate?

[degross77]

So instead of a straight average (38), i want to know if i can do a wa here... Based on impressions and clicks

[shg]

As just a WAG,

=SUM(Impressions)/SUMPRODUCT(Impressions*Impressions/Clicks) ~0.35%