Generate binomially distributed random numbers

Assignment Help Mechanical Engineering

Reference no: EM131173767

Suppose that Coke and Pepsi are fighting for the cola market. Each week each person in the market buys one case of Coke or Pepsi. If the person's last purchase was Coke, there is a 0.90 probability that this person's next purchase will be Coke; otherwise, it will be Pepsi. (You can assume that there are only two brands in the market.) Similarly, if the person's last purchase was Pepsi, there is a 0.80 probability that this person's next purchase will be Pepsi; otherwise, it will be Coke. Currently half of all people purchase Coke, and the other half purchase Pepsi. Simulate one year (52 weeks) of sales in the cola market and estimate each company's average weekly market share and each company's ending market share in week 52. Do this by assuming that the total market size is fixed at 100,000 customers. (Hint: Use the RISKBINOMIAL function. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the CRITBINOM function to generate binomially distributed random numbers. This takes the form =CRITBINOM(ntrials, psuccess,RAND()).)

Reference no: EM131173767

Questions Cloud

Graph three first-derivative finite difference approximation : Graph all three first-derivative finite difference approximations along with the theoretical, and do the same for the second derivative as well.

How many reservations for the flight should deleast book : On average, 95% of all people who have a reservation show up for the flight. To maximize expected profit, how many reservations for the flight should Deleast book?

How globalization has changed the way american companies : Describe how globalization has changed the way American companies are doing business. How do these strategies affect people in other parts of the world? In what ways do you believe this change has benefited American organizations and their customers?

How unconscious biases impact on auditor independence : Explain how unconscious biases impact on auditor Independence and explain the context surrounding the ‘ironic rebound effect'

Generate binomially distributed random numbers : (Hint: Use the RISKBINOMIAL function. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the CRITBINOM function to generate binomially distributed..

Determine the dimensions of the pit that minimize cost : You are asked to design a covered conical pit to store 50 m3 of waste liquid. Assume excavation costs at $100/m3, side lining costs at $50/m2, and cover cost at 25/m2. Determine the dimensions of the pit that minimize cost.

Calculate the internal rate of return for each project : BUACC3701: Financial Management Calculate the Net Present Value for each project and calculate the Internal Rate of Return for each project

Comment on any unusual aspects of the histogram : The file P20_47.xlsx contains the measured diameters (in inches) reported by the prod uction foreman of 500 rods produced by Rodco.

What was senior management typical approach toward quality : Prior to the advent of the total quality management concept, what was senior management's typical approach toward quality? What has led to the more comprehensive strategic view about total quality management?

User Account

All Pages