Normal Distribution Simulation on Excel or Python

A commercial land developer specializes in building shopping centers and wants to develop some property near Hilton Head, South Carolina. In order to develop the land, the developer must bid to obtain the property. The developer has estimated the NPV without the cost of the land to be $1,500,000. The developer has bid against several of the same competitors many times before and has the results of the bids as shown in Table 6.17. Table 6.17 Sales and Competitor's Advertising 1 390,000 10 920,200 19 1,007,100 2 1,110,500 11 1,035,400 20 303,200 3 944,000 12 911,000 21 945,200 4 1,139,100 13 945,100 22 933,500 5 1,177,300 14 1,007,600 23 1,153,600 6 1,030,100 15 1,075,100 24 1,135,300 7 1,021 ,200 16 1,025,200 25 934,900 8 903,000 17 961,100 9 1,051,300 13 1,103,900 a. Construct a cumulative distribution table and graph of the probability of winning the bid. 1). Construct a decision tree to determine the optimum bid. 1:. Construct a simulation to determine the optimum bid