Check My Work Suapoce that a popular hotzl for vacationers in Crianda, lor da, has a total of 100 dencical roams. As many major siri ne companies do, this hooel has adopted an averboaking colicy in an...

How would you do this in Excel (part e)

Extracted text: Check My Work Suapoce that a popular hotzl for vacationers in Crianda, lor da, has a total of 100 dencical roams. As many major siri ne companies do, this hooel has adopted an averboaking colicy in an cffort to maximize the usage of its availzble ladging capacity. Assume tha: anch patential hotel custamer halding a room resevatian, independently of orher customers, cancels the resarvation or simpy does nat shaw up at the hatel on a givan night winh prohability a.15. a. Find the Iargest number of rocm reservations that this hotel can took and still be at lcast 95% sure that cveryona shaws uo at the hatel will have a ropm on a given night. 341 O b. Given that the hotel books the number of reservations found In part a, tind the probability thet at least 90% of the avallable rooms will be occupled on a glven night. (Round your answer to three decinmal places.) 0.998 O c. Given thet the hotel books the number of reserverions found in part a. fing the probebilipy het at most B0% of the available rooms will be occupiec on e given night, (1 vour answer is zero, enter "0".1 d. How docs your answer to parta chanpa as the roquirod assurance rate increases frem 95% sa /9s7 339 O How does your answer to part a chanse as the raquired assurance rate increases fram 95% to 997 336 O e. Hur does your answer to pert a change as Lhe cancelletion rate varies belween 5% and 25% (in inrements of 5%)? Assurne now that the required assurerice rale rermeins at 95%. Cancellation rate 5% 361 K 10% 336 15% 228 20% 341 K 25% 230 Hide Feedback Partially Correct Check My Work DOUUL