Background data: Bates doesn't know if "half" is correct. He looked through his records, and found that of the most recent 150 guest visits at the motel, the shower curtain has been ripped and required replacement 85 times.

Question I: Bates thinks that switching to organic shower curtains makes financial sense as long as shower curtains are ripped no more than 60 percent of the time. Therefore, he wants to know if his data provides compelling evidence that the true rip rate is smaller than 60 percent. He (correctly) wishes to test: H0: = 0.60 versus Ha: < 0.60 Perform this hypothesis test at the 10% level. Show all relevant calculations, draw a picture, and explain how you reached your conclusion. Give your conclusion in terms of the statement of the problem. What is the prob-value for the test?

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