Question: PLEASE SHOW PROCESS IN EXCEL! ALSO, PLEASE SHOW FINAL ANSWER IN EXCEL! Assume that for this project to be completed, six independent tasks must be

PLEASE SHOW PROCESS IN EXCEL! ALSO, PLEASE SHOW FINAL ANSWER IN EXCEL!

Assume that for this project to be completed, six independent tasks must be completed. These tasks are proceeding in parallel by six different subcontractors. To keep it simple, let's assume that each task takes between 3 and 7 months to complete (uniformly distributed, i.e. equally likely to take any amount of time between 3 and 7 months). So, the mean time to complete each task is 5 months and the probability of any given task taking 5 months or longer is 0.5. However, the project is NOT considered complete until ALL six tasks are complete. Conduct an Excel spreadsheet based simulation (As we did for the two dice experiment) with 100 experiments to answer the following questions: Use only RAND function (do not use RANDBETWEEN

Q1: What is the probability that the project finishes in 5 months or less?

Q2: What is the expected project completion time?

Q3: Develop a table (using Frequency function) and a graph (histogram) of distribution of project completion times.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!