5. Graphical analysis: Need assistance generating bubble chart

• Graph Publishers on a bubble chart (in Excel, pick Bubble Chart) using the following dimensions: X=Probability of Booking, Y=Cost Per Click, Bubble Size=Total Costs.
• Create four quadrants by drawing a line at the publisher average for CPC and another line at the publisher average for probability of booking.

Data Volume of Sum of Total Publisher Name Sum of Clicks Sum of Impressions Bookings Sum of Amount Cost Google - Global 72895 1808326 797 929549.8 120946.712 Google - US 192 109 3855689 1550 1745481.8 353640.5989 MSN - Global 11217 139979 129 145524.25 12160.36244 MSN - US 10808 170120 140 181549.8 16098.48741 Overture - Global 60899 17898727 372 430084.7 64295.86214 Overture - US 1 19323 17062488 289 347433.25 141976.0745 Yahoo - US 45 598 933345 662 882288.95 46197.82462 Grand Total 512849 41868674 3939 4661912.55 755315.922 Average Cost Transaction Revenue Per Click Click Through Rate Conversion Sum of Net Return on Ad Per Probability of Cost/Booki (CPC) (CTR) Rate (TCR) Revenue Spent (ROA) Transaction Booking ng Publisher Name Google - Global 1.66 0.040 0.011 808603.09 6.69 1166.31 0.00044074 151.75 Google - US 1.84 0.050 0.008 139184 1.20 3.94 1126.12 0.000402 228.16 MSN - Global 1.08 0.080 0.012 133363.89 10.97 1128.09 0.00092157 94.27 MSN - US 1.49 0.064 0.013 16545 1.31 10.28 1296.78 0.00082295 1 14.99 Overture - Global 1.06 0.003 0.006 365788.84 5.69 1156. 14 2.0784E-05 172.84 Overture - US 1.19 0.007 0.002 205457.18 1.45 1202. 19 1.6938E-05 491.27 Yahoo - US 1.01 0.049 0.015 836091.13 18.10 1332.76 0.00070928 69.79 Grand Total 1.47 0.012 0.008 3906596.63 5.17 1183.53 9.408E-05 191.75