Background data: Arborgrass Consulting also recommended Bates consider a new line of organic shower curtains made from bamboo and hemp. Bates is intrigued, but he's worried whether he can afford it or not. Shower curtains at the Bates Motel are frequently getting ripped, and Bates incurs significant costs to replace them.

Question g: Suppose that a shower curtain becomes ripped on half of the motel's guest visits. What is the probability that Bates will have to replace at least one but not more than five shower curtains tomorrow morning? There are 10 guests staying at the hotel tonight.

Please answer the question using excel. Please show all formulas and calculations used to solve the question.