Summary Report On a separate sheet show average length of stay per room type, average number of visitors per room type, average base revenue per room type (i.e., length of visit multiplied by the daily rate), Total number of visitors per room type and total revenue per room type in a tabular format as shown in the screenshot Charts Show 2 charts underthe summary reporttable 1. Show a clustered ber chart depicting all the above summary date in the bar chart for each room type The chart should like the one in the solution screen shot 2. Show 2:d chart as stacked area chart to depict the trend of visitors coming to the hotel per day in the month of December. The chart should resemble the one in the solution screen shot Submit your excel file as an attachment to the homework assignment 2 submission