Pre-test (BSHM)

Which of the following is the most appropriate first step in analyzing a dataset?

• Conducting a regression analysis

• Visualizing data with charts

• Cleaning and pre-processing the data

• Drawing conclusions from raw data

A hotel uses customer feedback surveys to identify issues in service quality. The average score from 1,000 customer reviews is 4.2 out of 5. Which of the following is the best way to analyze trends in customer satisfaction?

• Conducting a sentiment analysis on customer reviews

• Focusing only on customers who scored 5

• Collecting feedback only from repeat customers

• Disregarding reviews older than 6 months

Which data visualization is most suitable for analyzing the relationship between room rates and occupancy rates in a hotel?

• Pie chart

• Line graph

• Scatter plot

• Histogram

A tourism agency notices an increase in cancellations during peak season. What could be a potential factor to investigate first?

• Social media engagement

• Price comparison with competitors

• Employee turnover rates

• Website traffic analytics

If a dataset contains missing values and outliers, which of the following is the best approach to ensure accurate analysis?

• Delete all rows with missing values and outliers

• Replace missing values with the dataset mean and investigate outliers

• Ignore the missing values and proceed with analysis

• Only focus on rows with complete data

Case Scenario:

A small public resort is experiencing a decline in revenue despite consistent occupancy rates. The management collects the following data for analysis:

Customer demographics: Most guests are Millennials and Gen Z, aged 20–35.

• Customer feedback: Guests frequently complain about outdated room amenities.

• Room rates: The resort’s rates are 10% higher than competitors.

• Seasonal trends: occupancy is higher during the summer but stagnant during off-peak seasons.

Question:

Based on the data provided, what are two factors contributing to the declining revenue?

Case Scenario:

A small public resort is experiencing a decline in revenue despite consistent occupancy rates. The management collects the following data for analysis:

Customer demographics: Most guests are Millennials and Gen Z, aged 20–35.

• Customer feedback: Guests frequently complain about outdated room amenities.

• Room rates: The resort’s rates are 10% higher than competitors.

• Seasonal trends: occupancy is higher during the summer but stagnant during off-peak seasons.

Question:

What data-driven solution may be considered by the management to improve guest satisfaction?

Case Scenario:
Café by the Bay, located at Laguna State Polytechnic University (CHMT Guest House), was established in September 2024. The café aims to serve affordable food and beverages, provide practical training for students, and generate income. To assess its performance, two key performance indicators (KPIs) were identified:

1. Average Daily Customers: 30 pax.

2. Daily Sales Target: ₱3,000.

During its first three months of operation (October–December 2024), the café struggled to meet its sales targets. As seen in the figure, it presents the sales performance of the cafe.

Question:

Calculate for the total expected sales for each month based on days of operation of Cafe by the Bay. Present according to month.

Case Scenario:
Café by the Bay, located at Laguna State Polytechnic University (CHMT Guest House), was established in September 2024. The café aims to serve affordable food and beverages, provide practical training for students, and generate income. To assess its performance, two key performance indicators (KPIs) were identified:

1. Average Daily Customers: 30 pax.

2. Daily Sales Target: ₱3,000.

During its first three months of operation (October–December 2024), the café struggled to meet its sales targets. As seen in the figure, it presents the sales performance of the cafe.

Question:

Suggest two marketing strategies the cafe can implement to increase daily sales.