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.