Data Analysis on Satisfactory in Moxy Hotel
Introduction
In this analysis of Moxy Hotel customer satisfaction, RStudio allows us to analyze customer feedback data, allowing for detailed insights into guest experiences. By using various R packages for data manipulation, statistical modeling, and visualization, such as ggplot2 and dplyr , we can analyze customer ratings on variables such as staff, cleanliness, parking and much more. We identify trends, and uncover key drivers of satisfaction. This analysis helps Moxy Hotel enhance its services by making data-driven decisions that align with guest expectations.
Average Satisfaction Scores by Category and Membership Level
From this bar chart we can see the average scores of satisfactory for each of the categories - clean common, dining price, front staff and perks.
With the colour coding we can see the difference of satisfactory levels for each membership level, making it easier to compare.
By comparing the bars we can see which category has the highest average satisfaction scores.
We can see that platnium membership level are overall most satisfied for all categories.
Nights Stayed vs. Distance Traveled
In this scatter plot we can see the nights stayed vs distance traveled by the reason for visit.
We can see outliers such as the customers who traveled the furthest and stayed longer than typical were for business purposes.
We can also see that the customer who stayed the longest visit purpose was a vacation.
The visit purpose sports event had the most customers who travelled the furthest.
Average Spending per Category by Membership Level
In this bar chart we can see the average spending categories per membership level.
Room spend is the highest average spend for all membership levels therefore it generates the most revenue for the hotel.
There is a very slight vary in average spend for each membership level this shows us that the membership level with the hotel does not dictate the amount the customer will spend.
Scatter Plot of Average Room Spend vs. Satisfaction with Room
This scatter plot shows us the relationship between average room spend and the customers satisfaction with room quality.
The trend line slopes downwards and shows negative correlation, this shows us the less they spend on a room the more satisfied they are with the room quality.
There is some outliers where a customer spends a lot but has a low satisfactory score.
Distribution of Spending Habits by Membership Level
Each box represents the distribution of spending for a specific membership level in a particular spending category.
The central line in each box indicates the median spending.
Correlation Heatmap of Satisfaction Variables
The darker shades of pink show us stronger positive correlation than the lighter shades of pink.
By focusing on areas with high positive correlation, the hotel can improve on these creating a higher overall satisfcation.
The number labels on the graph display to us the highest and lowest correlations.
Distribution of Satisfaction with City by Membership Level
Each “violin” represents the distribution of satisfaction scores for each membership level.
We can see that the silver status has the wider range of satisfactory scores as it has wider distribution.
| Customer Satisfaction by Membership Level1 | ||||
|---|---|---|---|---|
| Comparison of average satisfaction scores across various categories | ||||
| Membership Level | Cleanliness | Dining | Staff | Elite Perks |
| Platinum | 4.2 | 4.1 | 4.8 | 5.4 |
| Gold | 4.0 | 3.7 | 4.3 | 4.8 |
| Silver | 3.9 | 3.8 | 4.0 | 4.3 |
| NoStatus | 3.7 | 3.5 | 3.4 | 3.7 |
| 1 Satisfaction scores are averages based on customer feedback. | ||||
Customer Satisfaction by Membership Level
The table provides a color-coded comparison of average satisfaction scores across different hotel membership levels, in the categories - cleanliness, dining, staff, and elite perks.
Bonus Meme
