Question: Please, attach one Excel file with solutions to ALL exercises for this assignment. According to a recent survey by Smith Travel Research, the average daily

Please, attach one Excel file with solutions to ALL exercises for this assignment.

According to a recent survey by Smith Travel Research, the average daily rate for a luxury hotel in the United States is $237.22. Assume the daily rate follows a normal probability distribution with a standard deviation of $21.45.

What is the probability that a randomly selected luxury hotel's daily rate will be

a. Less than $250 per night?

b. More than $260?

c. Between $210 and $240?

d. The managers of a local luxury hotel would like to set the hotel's average daily rate at the 80th percentile, which is the rate below which 80% of hotels' rates are set. What rate should they choose for their hotel?

e. The managers of a local luxury hotel consider a price as a signal of a prestige of the hotel and would like to set the hotel's average daily rate not lower than 10% of the most expensive hotels. What rate should they choose for their hotel?

Please send me a excel like this:

Please, attach one Excel file with solutions to ALL exercises for this

\f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!