Data Analysis

2022-2

Program: EMIHM Course name and

No.:

S M 9115 Data Analytics

for Decision Making

Assessment title: Final Assessment (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 (35 pts)

A hotel manager wants to analyze the nationality of the guests who stayed at the hotel during

the last month. The data shows that approximately 20% of the guests were from Germany.

Suppose that you choose randomly 50 guests:

1. Find the probability that exactly 10 guests are from Germany.

2. Find the probability that at least 15 guests are from Germany.

3. Find the probability that at most 5 guests are from Germany.

4. Find the probability that more than 30 guests are from Germany.

5. What is the expected number of guests from Germany who stayed at the hotel during

the last month?

6. Calculate the variance and the standard deviation of this binomial distribution.

Problem 2 (35 pts)

The manager of a hotel chain is interested in knowing whether there is a relationship between

the number of positive reviews a hotel receives online and its occupancy rate. The manager

collected data from 10 hotels and recorded the number of positive reviews each hotel received

on a popular travel website and the corresponding occupancy rate (in percentage) for the

same period. The data is shown below:

Hotel Positive Reviews Occupancy Rate%

45 72

65 82

55 78

80 89

75 86

70 81

90 92

50 76

60 77

85 88

1. Determine the dependent and independent variables.

2. Calculate the correlation coefficient and comment.

3. Determine the regression equation �̂� = 𝑎 + 𝑏𝑋.

4. Give a brief interpretation for the values of “a” and “b”.

5. If the hotel had no positive reviews, what would the occupancy rate be?

Problem 3 (30 pts)

The revenue manager of a hotel chain wants to analyze the distribution of room rates for a

particular hotel location. Based on historical data, she estimates the following probability

distribution for the daily room rates:

Probability Room Rate

30% $100

40% $150

20% $200

5% $250

5% $300

Based on this distribution, what is the coefficient of variation for the room rates at this hotel

location?