Assignment Help - homework help

Use the norminv function and a one-way data table to


A garage band (imagine Metallica in early days) wants to hold a concert.

  • Suppose that the expected crowd is normally distributed with a mean of 3,000 and standard deviation of 200. 
  • The average expenditure on concessions is $15. 
  • Tickets sell for $10 each.
  • The band's profit is 80% of the gate and concession sales, minus a fixed cost of $10,000. 
  • Use the NORM.INV function and a one-way data table to conduct a Monte Carlo simulation with 25 trials to find the distribution of the expected profit.

Solution Preview :

Prepared by a verified Expert
Business Management: Use the norminv function and a one-way data table to
Reference No:- TGS02539812

Now Priced at $10 (50% Discount)

Recommended (90%)

Rated (4.3/5)