Construct a frequency table showing the categories, frequencies, and relative frequencies.

Calculate the mean revenue generated by the hotel’s different room types during the last quarter.

Data Analytics for Decision Making

Problem 1(12 pts)
Tell whether each variable, in the below statements, is quantitative or qualitative, then specify the level of measurement (Nominal, Ordinal, Interval, or Ratio) for each variable:

Variable                            Type of Variable                            Level of Measurement
Room temperature (0F) in
manager’s office.

The number of hours spent
on your laptop while
studying for the Data
Analytics exam

The color of walls in Al
Campo Hotel rooms

Student’s Rating
(Evaluation) of the Data
Analytics professor

The most popular Resort in
Marbella is Puente Romano

Number of employees
working at Moch restaurant
in Marbella

 

Problem 2 (18 pts)
A restaurant has collected data on the preferred cuisine types of its customers. The data collected from a sample of 30 customers is as follows: Italian, Mexican, Chinese, Indian, Italian, Mexican, Italian, Italian, Indian, Chinese, Mexican, Italian, Italian, Chinese, Indian, Mexican, Italian, Mexican, Chinese, Indian, Chinese, Italian, Indian, Mexican, Chinese, Italian, Italian, Indian, Chinese, Mexican

Construct a frequency table showing the categories, frequencies, and relative frequencies.
2. Is data Qualitative or Quantitative?
3. Based on the given data, which cuisine type is most preferred among the restaurant customers? Can you justify your answer using percentage relative frequency?
4. Represent your data using a pie or bar chart.

Problem 3 (35 pts)
The hotel manager of a luxury hotel is interested in analyzing the room occupancy rate for a given month. The manager has collected data on the number of rooms occupied per day and wants to represent this data in a frequency distribution.

What is the number of classes?
2. What is the class interval?
3. Construct a frequency distribution showing classes, class frequency & cumulative frequency.
4. Show your data using a graphical chart.

Data:
36, 41, 45, 52, 55, 58, 62, 66, 69, 70, 71, 72, 74, 76, 78, 79, 81, 83, 86, 88, 92, 95, 98, 101,104, 107, 110, 112, 115, 118, 121.

 

Problem 4 (35 pts)
A hotel manager wants to analyze the revenue generated by the hotel’s different room types during the last quarter. The revenue data for 10 different room types are given below:

Room Type A: $100,000
Room Type B: $120,000
Room Type C: $90,000
Room Type D: $80,000
Room Type E: $130,000
Room Type F: $110,000
Room Type G: $85,000
Room Type H: $95,000
Room Type I: $115,000
Room Type J: $125,000

Calculate the mean revenue generated by the hotel’s different room types during the last quarter.
2. Calculate the median revenue generated by the hotel’s different room types during the last quarter.
3. Identify the mode of the revenue data.
4. Compare the mean, median, and mode of the revenue data. Comment on the skewness of the distribution.
5. Calculate two measures of dispersion of your choice for this population or sample.