Events has been tracking various payment methods for tickets from their online booking portal. Their presence is completely online and accepts only three methods of payment: Credit Card: Paypal: and Apple Pay. Depending on the payment method used. Events automatically charges a commission fee based on the method and the ticket price. Customers using Paypal or Apple Pay are charged an additional fee of 1.5% of the ticket price, while if they use a Credit Card then the additional fee is 2% of the ticket price. The company wants you to analyse the patterns in payment method usage and determine if there has been an increase in revenue due to fee charges over the last three years. Table 1: Number of Payment Transactions at Events Number of Transactions at Events 2019 2020 1200 1500 1000 1000 400 500 Credit Card Apple Pay Paypal 2021 1600 1200 800 Table 2: Average Price of a ticket at g Events Average Price of a ticket at its 2019 2020 $40 $50 Price (S) 2021 $60 (a) (3 marks) Calculate the ratios between the total number of transactions of Credit Card and Apple Pay combined with Paypal transactions each financial year (Table 1). (b) (6 marks) Calculate the total average revenue Q Events produces each financial year from its ticket sales. (c) (3 marks) Using Excel, create a clustered column chart to visualise Table 1: Number of Payment Transactions ar & Events. For full marks annotate the graph with a meaningful title that includes your student network id. EXCEL Instructions