G53 for A D E F G H B Average 55 56 The webmaster is planning for the next quarter. Table 7 has the estimated conversion rates and table 8 has the estimate of the visitors. In table 9, he would like to compute the estimated number of visitors who will purchase. The mathematical formula to compute the number of visitors is. Estimated paying visitors= "Estimated visitors"* "conversion rate" (a) Enter a Formula in Cell C79 to compute the estimated number of paying visitors using cell C61 and C69. Copy the formula written in cell C79 to range C80:E83. (b) Write formula in cell G79 to compute the total number of estimated paying visitors across the months. Copy the formula in cell G79 to the range G80:G83. (c) Write formula in cell H79 to compute the average number of estimated paying visitors across the months. Copy the formula in cell H79 to the range H80:H83 57 58 59 60 61 62 Table 7: Estimated conversion rates Source Conversion Rate Display 10% Email 5% Organic Search 6% Paid Search 3% Social 5% 63 64 65 66 67 Table 8: Estimated visitors from various sources Apr, 2020 May, 2020 June, 2020 1462 69 70 71 72 Months () Sources (1) Display Email Organic Search Paid Search Social 1655 4480 1485 1688 4580 1732 820 1525 1700 4650 1771 1700 799 840 73 74 75 76 77 Table 9: Estimated No. of paying visitors Apr, 2020 May, 2020 June, 2020 Total Average 78 79 80 81 82 Months () Sources (1) Display Email Organic Search Paid Search Social 83 84