The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the 145 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests. Based on her experience, the wedding planner knows it is extremely rare for guests to attend a wedding if they notified that they will not be attending. Therefore, the wedding planner will assume that no one from these 50 invitations will attend. The wedding planner estimates that the each of the 25 guests planning to come solo has a 76% chance of attending alone, a 20% chance of not attending, and a 4% chance of bringing a companion. For each of the 60 RSVPs who plan to bring a companion, there is a 90% chance that they will attend with a companion, a 6% chance of attending solo, and a 4% chance of not attending at all. For the 10 people who have not responded, the wedding planner assumes that there is an 81% chance that each will not attend, a 14% chance each will attend alone, and a 5% chance each will attend with a companion. RSVPed Guests Number of Invitations 0 50 1 25 2 60 No response 10 (a) Assist the wedding planner by constructing a spreadsheet simulation model to determine the expected number of guests who will attend the reception. (Use at least 1,000 trials. Round your answer to the nearest integer.) (b) To be accommodating hosts, the couple has instructed the wedding planner to use the Monte Carlo simulation model to determine X, the minimum number of guests for which the caterer should prepare the meal, so that there is at least a 90% chance that the actual attendance is less than or equal to X. What is the best estimate for the value of X? (Use at least 1,000 trials. Round your answer to the nearest integer.)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

please help i am very stuck thankyou 

The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the
145 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests.
Based on her experience, the wedding planner knows it is extremely rare for guests to attend a wedding if they notified that they will not be attending. Therefore, the wedding planner will assume that no one from these 50 invitations will attend. The wedding planner estimates that the each of the 25 guests
planning to come solo has a 76% chance of attending alone, a 20% chance of not attending, and a 4% chance of bringing a companion. For each of the 60 RSVPs who plan to bring a companion, there is a 90% chance that they will attend with a companion, a 6% chance of attending solo, and a 4% chance of
not attending at all. For the 10 people who have not responded, the wedding planner assumes that there is an 81% chance that each will not attend, a 14% chance each will attend alone, and a 5% chance each will attend with a companion.
RSVPed Guests Number of Invitations
0
50
1
25
2
60
No response
10
(a) Assist the wedding planner by constructing a spreadsheet simulation model to determine the expected number of guests who will attend the reception. (Use at least 1,000 trials. Round your answer to the nearest integer.)
(b) To be accommodating hosts, the couple has instructed the wedding planner to use the Monte Carlo simulation model to determine X, the minimum number of guests for which the caterer should prepare the meal, so that there is at least a 90% chance that the actual attendance is less than or equal to X.
What is the best estimate for the value of X? (Use at least 1,000 trials. Round your answer to the nearest integer.)
Transcribed Image Text:The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the 145 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests. Based on her experience, the wedding planner knows it is extremely rare for guests to attend a wedding if they notified that they will not be attending. Therefore, the wedding planner will assume that no one from these 50 invitations will attend. The wedding planner estimates that the each of the 25 guests planning to come solo has a 76% chance of attending alone, a 20% chance of not attending, and a 4% chance of bringing a companion. For each of the 60 RSVPs who plan to bring a companion, there is a 90% chance that they will attend with a companion, a 6% chance of attending solo, and a 4% chance of not attending at all. For the 10 people who have not responded, the wedding planner assumes that there is an 81% chance that each will not attend, a 14% chance each will attend alone, and a 5% chance each will attend with a companion. RSVPed Guests Number of Invitations 0 50 1 25 2 60 No response 10 (a) Assist the wedding planner by constructing a spreadsheet simulation model to determine the expected number of guests who will attend the reception. (Use at least 1,000 trials. Round your answer to the nearest integer.) (b) To be accommodating hosts, the couple has instructed the wedding planner to use the Monte Carlo simulation model to determine X, the minimum number of guests for which the caterer should prepare the meal, so that there is at least a 90% chance that the actual attendance is less than or equal to X. What is the best estimate for the value of X? (Use at least 1,000 trials. Round your answer to the nearest integer.)
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman