Question: Please show me how to compute in excel. I need to figure out how to compute this in excel. Question 2 (4 parts): A software

Please show me how to compute in excel. I need to figure out how to compute this in excel.

 Please show me how to compute in excel. I need to

Question 2 (4 parts): A software company has undertaken a major project for an important client. The project involves three major phases: design, development, and testing. The amount of time it takes to complete each phase is normally distributed with parameters given in the table below. Phase Mean (4) Standard Deviation (o) Design 30 weeks 10 weeks Development 45 weeks 15 weeks Testing 8 weeks 2 weeks Assume that the time it takes to complete each phase is independent of the others. a. What is the probability that the development phase is completed in less than 52 weeks (i.e., one year)? b. What is the probability that the entire project is completed in less than 78 weeks (i.e., a year and a half)? Hint: the entire project requires the completion of each phase, one after the other. c. What is the probability that the entire project is completed in more than 104 weeks (i.e., two years)? Hint: the entire project requires the completion of each phase, one after the other. d. As an incentive for the software company to work faster, the client has offered to pay a $100,000 bonus if the entire project is completed in less than a year and a half, but will charge a $100,000 penalty if the project takes more than two years. Should the software company take this deal? Briefly explain your

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 Mathematics Questions!