Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started