Task 4

A small hotel in central London has 10 rooms. Based on data collected over the last five years, it was estimated that the probability a room is occupied on any “weekend” night (Saturday and Sunday) is 0.8. This is the probability of success. On any “weekend” night, a hotel is only occupied (Success) or not occupied (Failure). There are no other possibilities. 

Required:

What is the probability that at least 7 of the 10 hotel rooms are occupied on any weekend night? 

Note: Show all your calculations in well laid-out Excel spreadsheet tables with clear headings and include formulas. Give your answers correct to 3 decimal places.