Question

Your 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.

1. Develop two unique ways to display the data (two unique types of charts) to show him where he should stay.

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

1) Two unique charts to show all the scores so that the professor could choose one hotel are:

The above graph would be great as it shows all the scores in one bar for each hotel. Hence, it is not too congested.

The other graph could be a bar graph with different bars for each score:

2)The best way to represent the data would be the first graph which has only one bar for each hotel. All the scores are easy to visualize in this bar graph.

Let's recommend the professor to choose the hotel which he should stay in. THe professor loves food and wants to do all the activities at the resort. Hence, we should majorly focus on In-House dining and Amenities but not compromising on the overall score of the Hotel. If we choose the hotel with the best overall score (Muri Beach Odyssey), we are compromising on the amenities. If we take a look at the top 5 hotels on the basis of the overall scores, Spa Carribe seems to be the best possible option for the professor as the Amenities Score = 94.7 and House Dining score = 97 which are the best in the league. By choosing this hotel, he would not have to compromise on the overall score as well but there would be a little tradeoff in the comfort levels. Hence, the recommendation to the professor would be to choose Spa Carribe Resort with an overall score of 91.2