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 answer the door, 80% of the time it is a female and 20% of the time it is a male. The also know that 70% of females who answer the door donate, whereas only 40% of the males who answer the door make donations. The amount of money that females $20andstandarddeviationof3.The amount of money that males contribute follows a normal distribution with a mean of $10 and standard deviation of2.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 Heart Association can expect to receive in donations?