Door-to-Door Marketing. A small nonprofit organization is planning a door-to-door marketing campaign to sell Christmas wrapping and gifts. They plan to visit 100 homes. Consultants have estimated that they should expect to find someone home 80 percent of the time. When someone is home, 65 percent of the time it is a female. Thirty percent of females make a purchase, and when they do so the dollar value of their purchase is normally distributed with a mean of $22 and a standard deviation of $5. Males purchase 20 percent of the time, and the dollar value of their purchase is normally distributed with a mean of $28 and a standard deviation of $3.
a. What is the total amount they can expect to generate in revenues from these 10 visits?
b. What is the standard deviation of total revenues over 10 visits?
c. What is the probability they will make more than $750?
PLEASE USE SOLVER FOR EXCEL. That is what I am using and my answer doesn't make any sense!
Currently, I have
visit someone answers female male purchase by female purchase by male Female Purchase Amount Male Purchase Amount
1 IF(RAND()<=0.2,1,0) B2*IF(RAND()<=0.65,1,0) B2*(1-C2) C2*IF(RAND()<=0.3,1,0) D2*IF(RAND()<=0.2,1,0) IF(E2=1, PsiNormal(22,5), 0) IF(F2=1, PsiNormal(28,3),0)
2 1 0 1 0 0 $0.00 $0.00
3 1 1 0 0 0 $0.00 $0.00
4 1 1 0 0 0 $0.00 $0.00
5 1 0 1 0 0 $0.00 $0.00
6 1 1 0 0 0 $0.00 $0.00
7 1 1 0 0 0 $0.00 $0.00
8 1 1 0 0 0 $0.00 $0.00
9 1 1 0 0 0 $0.00 $0.00
10 1 1 0 0 0 $0.00 $0.00
TOTAL SUM(G2:H11)+PsiOutput()
Solved
Show answers
More tips
- A Animals and plants What Do Terriers Eat?...
- F Food and Cooking Discover the Benefits and Properties of Dates...
- C Computers and Internet Dynamically Assigned IP Address: What Is It and How Does It Work?...
- S Style and Beauty How to Get Rid of Acne: Scientifically Proven Methods...
- H Health and Medicine Simple Ways to Lower Cholesterol in the Blood: Tips and Tricks...
- O Other How to Choose the Best Answer to Your Question on The Grand Question ?...
- L Leisure and Entertainment History of International Women s Day: When Did the Celebration of March 8th Begin?...
- S Style and Beauty Intimate Haircut: The Reasons, Popularity, and Risks...
- A Art and Culture When Will Eurovision 2011 Take Place?...
- S Style and Beauty How to Choose the Perfect Hair Straightener?...
Answers on questions: Business
- B Business NoreCorp wants to meet a moral minimum of ethical behavior...
- B Business Open market operations refer to decisions to Multiple Choice buy or sell U.S. Treasury bills and other investments in the open market. issue savings accounts and certificates...
- B Business anson Company owns 20,000 of the 50,000 outstanding shares of Evergreen, Inc. common stock. During 2021, Evergreen earns $1,200,000 and pays cash dividends of $960,000....
- B Business A single firm that charges the monopoly price in the market earns $1,300. If another firm successfully enters the market, the incumbent s profits fall to $700 and the...
- B Business Suppose that you buy a €1,000,000 call option against dollars with a strike price of $1.2750/€. Describe this option as the right to sell a specific amount of dollars...
- B Business The Blue Star generally receives only three checks a month with amounts of $14,809, $16,211, and $14,750. These checks all have a collection delay of 1.5 days. Given...
- B Business Bondholders tend to offset the effects of selfish strategies implemented by shareholders by: Multiple Choice increasing the interest rate on monies loaned to the firm....
- B Biology A large power plant burns coal to generate electricity for nearby homes and businesses. This contributes most directly to which short-term human-induced environmental...
- M Mathematics Evaluate each expression. Express your answer in scientific notation. (1.5 x 10^2)(5x10^10) 4.8 x 10^-8 / 3x10^-3 (5 x 10^8)(4x10^3) (7.2x10^3)÷(1.2 x 10^5)...
- H History What does eye of the storm present an example of?...
Ответ:
yes
Explanation: