please answer from question 2nd

CHAPTER 3: ANALYTICS Group Assignment Conversion Funnel Exercise Examine the following hypothetical conversion funnel for the Marriott Hotels website. The Rates & Availability page is the page that comes up after someone does a search for hotel rooms in a particular location and timeframe. Rates & Availability 2,347,892 Review Itinerary 367,495 Guest Info 103,471 Confirmation 72,498 Revenue: $23,464,220 Room Nights: 143,285 Perform the Following Calculations: 1. Calculate the conversion rate. (The conversion rate is usually calculated as the percentage of sessions that result in a conversion. Here, we will calculate the percentage of hotel searches that result in a conversion ) 2. Calculate the three step-to-step micro-conversions. (For example, what percentage of people advance from the Rates & Availability page to the Review Itinerary page?) 3. Calculate the average number of nights per booking 4. Calculate the average revenue per booking 5. Calculate the average revenue per night 6. If you could increase traffic by 10%, how much would revenue increase (assuming the new traffic was of the same character as the current traffic: same conversion rate, same average nights per booking, etc.)? How many more confirmations would result? 7. If you could increase the percentage of those who reviewed the itinerary from 15.65% to 20%, how would the conversion rate be affected? 8. You believe that if you offered a 10% discount on all bookings, the conversion rate would increase to 3.5% Would this increase or decrease revenue? Extra credit: Would this be a profitable action if the gross margin on bookings (before the 10% discount) is 50%? 9. Which of the three steps in the conversion funnel do you believe should be improved? Think carefully about the hotel booking process and where Marriott Hotels seems to be performing poorly. Even though the first step has the lowest rate, this might just be the nature of hotel searches (meaning lots of people do searches out of curiosity or advanced planning without any intention of booking) 10. Come up with a promotion for Marriott Hotels Perform a hypothetical analysis of the effect of this promotion. That is, spoofy how this promotion would affect this month's traffic inte find the enerifi stone and FOM (11 1.59 192PM