Your BANA II professor is going on vacation. He has narroweddown a list of potential hotels, but he is still overwhelmed by thedata. He loves great food and wants to do all the activities at theresort. Refer to the attached Excel workbook to complete thefollowing 2 questions: 1. Develop two unique ways to display thedata (two unique types of charts) to show him where he should stay.Save the graphs in the Blackboard Midterm Tab. Make sure to labeland describe the data in the chart. Be creative and impress yourprofessor. 2. Recommend the best way to present the data. Write anarrative summary of what hotel you recommend based on the datavisualization and the tradeoffs that you observe.

Hotel	Overall	Comfort	Amenities	In-House Dining
Muri Beach Odyssey	94.3	94.5	90.8	97.7
Pattaya Resort	92.9	96.6	84.1	96.6
Sojourner’s Respite	92.8	99.9	100	88.4
Spa Carribe	91.2	88.5	94.7	97
Penang Resort and Spa	90.4	95	87.8	91.1
Mokihana H?kele	90.2	92.4	82	98.7
Theo’s of Cape Town	90.1	95.9	86.2	91.9
Cap d’Agde Resort	89.8	92.5	92.5	88.8
Spirit of Mykonos	89.3	94.6	85.8	90.7
Turismo del Mar	89.1	90.5	83.2	90.4
Hotel Iguana	89.1	90.8	81.9	88.5
Sidi Abdel Rahman Palace	89	93	93	89.6
Sainte-Maxime Quarters	88.6	92.5	78.2	91.2
Rotorua Inn	87.1	93	91.6	73.5
Club Lapu-Lapu	87.1	90.9	74.9	89.6
Terracina Retreat	86.5	94.3	78	91.5
Hacienda Punta Barco	86.1	95.4	77.3	90.8
Rendezvous Kolocep	86	94.8	76.4	91.4
Cabo de Gata Vista	86	92	72.2	89.2
Sanya Deluxe	85.1	93.4	77.3	91.8