Data Analysis
2022-2
Program: EMIHM Course name and
No.:
S M 9115 Data Analytics
for Decision Making
Assessment title: Assessment Two (35%) Type: Practical
Faculty: Dr. Ahmed Bakri Deadline April 30, 2023 23:59
Dear Students,
Please solve the following problems on Excel (where needed) and kindly
upload the excel file on Moodle when done.
Please rename the file with your name.
Good Luck.
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
1. 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.
1. 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
1. 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.