2.) USE Microsoft Excel’s Analytic Solver Platform to solve

2.) USE Microsoft Excel’s Analytic Solver Platform to solve

2.)
USE Microsoft Excel’s Analytic Solver Platform to solve the question below:
An organization is performing a door-to-door marketing campaign to sell goods to consumers. They will visit 30 homes. Consultants estimated they expect to find someone home 80% of the time. When someone is home 65% it is a female. 30% of females make a purchase, and when they make a purchase it is normally distributed with a mean of $22 and a standard deviation of $5. 20% of males make a purcahse, and when they do it is normall distributed with a mean of $28 and a standard deviation of $3.
1.) What is the total amount they can expect to generate in revenues from these 30 visits?
2.) What is the standard deviation of total revenues over 30 visits?
3.) What is the probability they will make more than 100?

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.

Discount Code: CIPD30

Click ORDER NOW..