Question

Your BANA II professor is going on vacation. He has narrowed down a list of potential hotels, but he is still overwhelmed by the data. He loves great food and wants to do all the activities at the resort. Refer to the attached Excel workbook to complete the following 2 questions: 1. Develop two unique ways to display the data (two unique types of charts) to show him where he should stay. Save the graphs in the Blackboard Midterm Tab. Make sure to label and describe the data in the chart. Be creative and impress your professor. 2. Recommend the best way to present the data. Write a narrative summary of what hotel you recommend based on the data visualization 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

Answer 1

We can display the data in one better way that is the bar graph.

If we compare by overall column then he should prefer Murli beach odyssey.

If we compare by comfort then he should prefer Sojourner's Respite.

If we compare by amenities then again he should prefer Sojourner's Respite.

If we compare by In-House dining then he should prefer Mokihana Hokele.

And if we compare all the factors together then he should consider Cap d' Agde Resort and Sidi Abdel Rahman Palace are to be preferred by the Professor because both the hotels have the four factors near about equal.