Final answer:
To estimate the minimum bid distribution and its expected value for a government contract with bids normally distributed, you would use spreadsheet software to simulate the bids and calculate the minimum using specified formulas.
Step-by-step explanation:
To estimate the distribution of the minimum bid and the expected value of the minimum bid when ten contractors are expected to submit bids with a normal distribution, a mean of $3.3 million, and a standard deviation of $0.27 million, you would follow the steps provided in a spreadsheet software.
- Enter "Mean" in cell A1 and "Std Dev" in cell A2. Then, put 3300000 in cell B1 and 270000 in cell B2.
- Label cells C1 through L1 with "Bid 1" through "Bid 10" to represent each contractor's bid.
- In cells C2 through C11 enter the formula =NORM.INV(RAND(), $B$1, $B$2). This formula generates random numbers based on the specified normal distribution for the first contractor's bid.
- Copy the formula from step 3 for the remaining columns D through L to simulate the bids for the other contractors.
- In cell M1, enter the header "Winner", and in cell M2, input the formula =MIN(C2:L2) to calculate the minimum bid, which would be the winning bid. Copy this formula down for each row of simulated bids.
To estimate the expected value of the minimum bid after running the simulation many times, you would take the average of the winning bids. This process involves statistical simulation and provides an illustration of how the minimum bid may be distributed and how the lowest bid can be expected on an average basis.