0.25 10 0.10 12 0.25 14 0.35 16 0.25 18 0.05 0.65 10 0.35 (a) Construct a spreadsheet simulation model to estimate the average length of the project (in weeks) and the standard deviation of the...

Find part a and b
0.25<br>10<br>0.10<br>12<br>0.25<br>14<br>0.35<br>16<br>0.25<br>18<br>0.05<br>0.65<br>10<br>0.35<br>(a)<br>Construct a spreadsheet simulation model to estimate the average length of the project (in weeks) and the standard deviation of the project length. (Use at least 1,000 trials. Round you<br>answers to one decimal place.)<br>average<br>weeks<br>standard deviation<br>weeks<br>(b) What is the estimated probability that the project will be completed in 35 weeks or less? (Use at least 1,000 trials. Round your answer to three decimal places.)<br>

Extracted text: 0.25 10 0.10 12 0.25 14 0.35 16 0.25 18 0.05 0.65 10 0.35 (a) Construct a spreadsheet simulation model to estimate the average length of the project (in weeks) and the standard deviation of the project length. (Use at least 1,000 trials. Round you answers to one decimal place.) average weeks standard deviation weeks (b) What is the estimated probability that the project will be completed in 35 weeks or less? (Use at least 1,000 trials. Round your answer to three decimal places.)
A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows.<br>Activity<br>Activity Time (weeks)<br>Probability<br>5.<br>0.20<br>6<br>0.35<br>0.30<br>8<br>0.15<br>в<br>3<br>0.15<br>0.60<br>0.25<br>10<br>0.10<br>12<br>0.25<br>14<br>0.35<br>16<br>0.25<br>18<br>0.05<br>D<br>8<br>0.65<br>10<br>0.35<br>(a) Construct a spreadsheet simulation model to estimate the average length of the project (in weeks) and the standard deviation of the project length. (Use at least 1,000 trials. Round you<br>

Extracted text: A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows. Activity Activity Time (weeks) Probability 5. 0.20 6 0.35 0.30 8 0.15 в 3 0.15 0.60 0.25 10 0.10 12 0.25 14 0.35 16 0.25 18 0.05 D 8 0.65 10 0.35 (a) Construct a spreadsheet simulation model to estimate the average length of the project (in weeks) and the standard deviation of the project length. (Use at least 1,000 trials. Round you

Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here