Homework Help is Here – Start Your Trial Now!
Math
Statistics
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 B с D Activity Time (weeks) 5 6 7 8 3 5 7 10 12 14 16 18 8 10 Probability 0.30 0.35 0.20 0.15 0.25 0.50 0.25 0.10 0.25 0.45 0.15 0.05 0.65 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

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 B с D Activity Time (weeks) 5 6 7 8 3 5 7 10 12 14 16 18 8 10 Probability 0.30 0.35 0.20 0.15 0.25 0.50 0.25 0.10 0.25 0.45 0.15 0.05 0.65 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

College Algebra
College Algebra
10th Edition
ISBN:9781337282291
Author:Ron Larson
Publisher:Ron Larson
Chapter8: Sequences, Series,and Probability
Section8.7: Probability
Problem 38E
See similar textbooks
icon
Related questions
Question
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 B с 5 6 7 8 3 5 7 10 12 14 16 18 8 10 0.30 ***E 0.35 0.20 0.15 0.25 0.50 0.25 0.10 0.25 0.45 0.15 0.05 0.65 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
Transcribed Image 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 B с 5 6 7 8 3 5 7 10 12 14 16 18 8 10 0.30 ***E 0.35 0.20 0.15 0.25 0.50 0.25 0.10 0.25 0.45 0.15 0.05 0.65 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
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS