Question: Im just cocbfused with how i would input this in excel. if you could tell me the formula to finding it in excel would be

You may need to use the appropriate appendix table to answer this question. New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $204 per night. + Assume that room rates are normally distributed with a standard deviation of $55. (a) What is the probability that a hotel room costs $235 or more per night? (Round your answer to four decimal places.) (b) What is the probability that a hotel room costs less than $140 per night? (Round your answer to four decimal places.) (c) What is the probability that a hotel room costs between $200 and $290 per night? (Round your answer to four decimal places.) (d) What is the cost in doliars of the 20% most expensive hotel rooms in New York City? (Round your answer to the nearest cent.) You may need to use the appropriate appendix table to answer this question. The time needed to complete a final examination in a particular college course is normally distributed with a mean of 80 minutes and a standard deviation of 10 minute-s. Answer the following questions. (a) What is the probability of completing the exam in one hour or less? (Round your answer to four decimal places.) (b) What is the probability that a student will complete the exam in more than 60 minutes but less than 75 minutes? (Round your answer to four decimal places.) (c) Assume that the class has 70 students and that the examination period is 95 minutes in length. How many students do you expect will be unable to complete the exam in the allotted time? (Round your answer up to the nearest integer.) students
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
