Question

(All answers were generated using 1,000 trials and native Excel functionality.) A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for th...

(All answers were generated using 1,000 trials and native Excel functionality.) 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 A 5 0.25 6 0.35 7 0.25 8 0.15 B 3 0.20 5 0.55 7 0.25 C 10 0.10 12 0.25 14 0.40 16 0.20 18 0.05 D 8 0.60 10 0.40

(a) Construct a spreadsheet simulation model to estimate the average length of the project and the standard deviation of the project length. Round your answers to one decimal place. Average Project Length weeks Standard Deviation in Project Length weeks

(b) What is the estimated probability that the project will be completed in 35 weeks or less? Round your answer to a whole percentage. %

0 0
Add a comment Improve this question Transcribed image text
Answer #1

S Ution Ace vityfire 6.2S 2 o .as PST I.8 3.15 2.7s 0.2 ㅇ o.SS 3 6 2. S). 2 38. y 3 /yOn-ine ta ble ,tve epettc d ~etu e 6°丫E2. (4)) 1 23.2 101 + ,7944114 6:94 7-8m ne estimaied poiecte d ompiet e in sruees Gs SD CP) 2.8 Scanned with CamScanner

Add a comment
Know the answer?
Add Answer to:
(All answers were generated using 1,000 trials and native Excel functionality.) A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for th...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT