BUSINESS STAT HOMEWORK

· After you have uploaded your file in the Assignments area, answer the following questions in your discussion board essay:

1. Based on your contingency table analysis, describe two things you have learned from your data that would help your friend to market better to customers in various plans. 

2. Suppose your friend wants to ensure that the probability of having two or more of the machines broken broken is no greater than 0.05. Based on your data, is this possible? Explain. Hint: Think about the P(X >= 2). What suggestions do you have for your friend to increase uptime?

3. Your friend wants to ensure that he has sufficient staff to assist customers at the spa. Assume that customers who arrive in the spa usually spend one hour. He needs one staff member to man the reception desk and one additional staff member per five spa customers. How many staff members should he schedule each hour? Explain.

4. Based on your analysis of the fitness profiles, how could you use this information to ensure that he has sufficient fitness staff to do the profiles?

5. What did you learn from the project itself? Do you see yourself using Excel to do this sort of analysis in the future? Why or why not?