Description2022-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

45

65

55

80

75

70

90

50

60

85

Occupancy Rate%

72

82

78

89

86

81

92

76

77

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%

40%

20%

5%

5%

$100

$150

$200

$250

$300

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

location?

Purchase answer to see full

attachment

**We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.**

#### Why Choose Us

- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee

#### How it Works

- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "
**PAPER DETAILS**" section. - Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “
**CREATE ACCOUNT & SIGN IN**” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page. - From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.