Question
Representatives from the American Heart Association are planning to go door to door throughout a community, soliciting contributions. From past experience, they know that when
Representatives from the American Heart Association are planning to go door to door throughout a community, soliciting contributions. From past experience, they know that when someone answers the door. 80% of the time it is a female. and 20% of the time it is a male. They also know that 70% of the females who answer the door make a donation, whereas only 40% of the males who answer the door make donations. The amount of money that females contribute follows a normal distribution with a mean of $20 and standard deviation of $3. The amount of money males contribute follows a normal distribution with a mean of $10 and standard deviation of $2
a. Create a spreadsheet model that simulates what might happen whenever a representative of the American Heart Association knocks on a door and someone answers.
b. what is the average contribution the American Heart Association can expect to receive when someone answers the door?
c. Suppose that the American Heart Association plans to visit 300 homes on a given Saturday. If no one is home at 25% of the residences, what is the total amount that the American Head Association can expect to receive in donations?
Step by Step Solution
3.45 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
In order to detect whether a male or a female answers the knock on the door the function used is IF ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 2 attachments)
60964c0fe9eb0_26772.pdf
180 KBs PDF File
60964c0fe9eb0_26772.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started