Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
60964c0fe9eb0_26772.pdf

180 KBs PDF File

Word file Icon
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

Recommended Textbook for

Essentials Of Statistics For Business And Economics

Authors: David Anderson, Thomas Williams, Dennis Sweeney, Jeffrey Cam

7th Edition

1305081595, 978-1305081598

More Books

Students also viewed these Mathematics questions

Question

Describe the three major subdivisions of the Malleus Maleficarum.

Answered: 1 week ago