Question: how to put problem into excel as well as solving The Zagat Restaurant Survey provides food, decor, and service ratings for some of the top

how to put problem into excel as well as solving
how to put problem into excel as well as solving
The Zagat Restaurant Survey provides food, decor, and service ratings for some of the top restaurants across the United States. For 15 restaurants located in Boston, the average price of a dinner, including one drink and tip, was $48.60. You are leaving on a business trip to Boston and will eat dinner at three of these restaurants. Your company will reimburse you for a maximum of $50 per dinner. Business associates familiar with these restaurants have told you that the meal cost at one-third of these restaurants will exceed $50. Suppose that you randomly select three of these restaurants for dinner. a. What is the probability that none of the meals will expued the cost covered by your company? b. What is the probability that one of the meals will exceed the cost covered by your company? c. What is the probability that two of the meals will exceed the cost covered by your company? d. What is the probability that all three of the meals will exceed the cost covered by your company? Hint: All parts involve the hypergeometric distribution Show your work albegraically and check it using an Excel function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!