DO THIS IN EXCEL and use only the formulas he said to use and show them please.

A drug company is planning to invest in a new drug. The cost of research has a uniform distribution on $300,000 to $500,000. There is a 40% chance that the drug will not be effective, in which case th H D F G I J K L M Total Profit 17 20 16 A drug company is planning to invest in a new drug. The cost of research has a 18 uniform distribution on $300,000 to $500,000. There is a 40% chance that the 19 drug will not be effective, in which case there will be no sales. If the drug is 21 effective, then the total market for the drug is 400,000 people. The company expects their share of the market to have a triangular distribution with minimum 24 5%, maximum 30%, and most likely 20% of the people. For each person who uses the new drug, the company expects to make $100 in sales during the first 27 year. The drug company would like to know the distribution of profit they can expect from undertaking this investment. 23 Cost of Drug Development Function Library Question 2 Question 1 Accessibility: Investigate Question 3 Effectiveness Market Share Revenue per person Number of People Total Revenue Revenue Question 4 Question 5 Calculate Sheet E Calculation Use binomial inverse function to simulate if the drug will be effective or not. Use traingular Inverse function to simulate the market share. Use uniform function to simulate the cost of research. E B p

A drug company is planning to invest in a new drug. The cost of research has a uniform distribution on $300,000 to $500,000. There is a 40% chance that the drug will not be effective, in which case there will be no sales. If the drug is effective, then the fotal market for the drug is 400,000 people. The company expects their share of the market to have a triangular distribution with minimum 5%, maximum 30%, and most likely 20% of the people. For each person who uses the new drug, the company expects to make $100 in sales during the first year. The drug company would like to know the distribution of profit they can expect from undertaking this imvestment: A drug company is planning to invest in a new drug. The cost of research has a uniform distribution on $300,000 to $500,000. There is a 40% chance that the drug will not be effective, in which case there will be no sales. If the drug is effective, then the fotal market for the drug is 400,000 people. The company expects their share of the market to have a triangular distribution with minimum 5%, maximum 30%, and most likely 20% of the people. For each person who uses the new drug, the company expects to make $100 in sales during the first year. The drug company would like to know the distribution of profit they can expect from undertaking this imvestment