$1.$ Using an Excel worksheet for a content analysis of The Westin Melbourne guests' reviews that were posted on the TripAdvisor website

Please start looking at The Westin Melbourne's website and TripAdvisor.

Read as many as $100$ reviews $($but then select only $70)$ and collect data

$-$ Get a grip on the key issues

$-$ Decide on your headings$/$columns that will clearly highlight the issues

$-$ Copy $70$ selected comments across from TripAdvisor

$-$ Colour code the comments $-$ Red for negative and Green for positive

$-$ Transfer coloured sections into the correct column.

$2.$ The content analysis results and suggestions report for improvement to the executives:

$-$ Describe The Westin Melbourne $-$ size, location, amenities, unique selling proposition, and target market.

$-$ Method: describe the method and the process of the content analysis

$-$ Results: describe the results of guest perception from the content analysis and provide insights into the hotel attributes $($or product$/$service components$)$ guests care about at The Westin Melbourne hotel including the most crucial aspects they like and those in need of improvement as perceived by guests

$-$ Discussion$/$Conclusion: discuss the potential adverse effects of the aspects$/$issues perceived negatively by the hotel guests