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:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started