Question: please provide excel formulas so that I can work on the problems on excel besides having the answer. i want to learn how to get

Building a backyard swimming pool consists of nine major activities. The activities are as shown in the network: diagram. Note: There are 3 paths in this network (posted on Canvas as a separate attachment). The Excel file is also posted on Canvas as a separate Excel file. Assume the activity time estimates (in days) for the swimming pool construction project are as follows: What is the probability that the project can be completed within a deadline of 18 days? Assumption: If the z-value of a path is greater than or equal to 3 , then there is a 100% probability that the path will be done as per its expected time. Problem thetwork (PERT based problem) Hint: There are THREE paths in this network ( 1 am giving this information so that you minimize your errors). PROBLEM 3 Deadline 18 DAYS Prob(Project 18 days) In Percentage Building a backyard swimming pool consists of nine major activities. The activities are as shown in the network: diagram. Note: There are 3 paths in this network (posted on Canvas as a separate attachment). The Excel file is also posted on Canvas as a separate Excel file. Assume the activity time estimates (in days) for the swimming pool construction project are as follows: What is the probability that the project can be completed within a deadline of 18 days? Assumption: If the z-value of a path is greater than or equal to 3 , then there is a 100% probability that the path will be done as per its expected time. Problem thetwork (PERT based problem) Hint: There are THREE paths in this network ( 1 am giving this information so that you minimize your errors). PROBLEM 3 Deadline 18 DAYS Prob(Project 18 days) In Percentage
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
