(h) Using the SUMIF function, write a formula in cell F46 to compute the project's variance. (i) Project's standard deviation is the square root of the variance. Write a formula in cell F48 to compute the project's standard deviation.
(h) Using the SUMIF function, write a formula in cell F46 to compute the project's variance. (i) Project's standard deviation is the square root of the variance. Write a formula in cell F48 to compute the project's standard deviation.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
(h) Using the SUMIF function, write a formula in cell F46 to compute the project's variance.
(i) Project's standard deviation is the square root of the variance. Write a formula in cell F48 to compute the project's standard deviation.
Screenshots attached thanks
Transcribed Image Text:45
46
47
50
51
52
53
55
56
60
61
62
A B
с
D
Project's Variance
E
Project's standard deviation
Project's Expected Duration
Target days to complete
Probability that the project will be
complete in 35 days
F
G
H
K
L
M
N
O
Sample Answer
Project's Variance
Project's standard deviation
Project's Expected Duration
Target days to complete
Probability that the project will be
complete in 35 days
P
1.93
1.3892
33.6
35
84.32%
Q
R
Transcribed Image Text:A B C
D
E
F
G
H
T
J
Next, you would like to determine the variance of the project. Table 6 has the activity schedule for the seven activities.
This schedule is determined using a network diagram; please refer to Figure 7.6 in the book.
(g) Using the IF function, write a formula in J38 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J39:144.
To calculate the entire project's variance, we simply add variance for activities on the critical path.
(h) Using the SUMIF function, write a formula in cell F46 to compute the project's variance.
(i) Project's standard deviation is the square root of the variance. Write a formula in cell F48 to compute the project's standard deviation.
(j)The earliest finish time for the last activity is the Project's duration. Write a formula in cell F50 to compute the project's duration. (Hint: You have to only refer to the cell range)
We would like to use the variance information to compute the probability that the entire project will be complete in 35 days.
In Excel, the probability can be computed using NORM.DIST function. NORM.DIST function takes four arguments, viz, X, mean, standard_dev (standard deviation), and cumulative (whether
the probability is cumulative or not). X is the target days to complete (cell F52), the mean is the project's expected duration (cell F50), the standard_dev is the standard deviation (F48), and
the cumulative probability is TRUE.
To see how to apply NORM.DIST function, you can watch the youtube videos (i) https://www.youtube.com/watch?v=OCJudfW_gHY or (ii) https://www.youtube.com/watch?v=p_KApjpyBHE
33 (k) Using NORM.DIST function, write a formula in cell F54 to compute the probability that the entire project will be complete in 35 days.
34
35
36
37
38
39
40
41
42
43
44
45
Activity Earliest Start Earliest Finish Latest Start
A
B
с
D
E
3
F
G
ES
0
0
10
7
=
Table 6: Activity schedule for the seven activities of the project
Variance
(rounded to 2
decimal places)
7
2
16
16.5
25.8
EF
7
9.3
16
16.5
25.8
25
33.6
LS
0
6.7
7
7.8
16
17.3
25.8
Latest
Finish
LF
7
16
16
17.3
25.8
25.8
33.6
Slack
(LS - ES)
0
9.3
0
0.8
0
0.8
0
0.1100
1.7800
0.4400
1.3600
0.6900
0.2500
0.6900
Is the Activity
Critical?
K
A
B
C
L
D
E
F
G
Activity Earliest Start Earliest Finish Latest Start
ES
0
M
0
7
7
16
16.5
25.8
N
Sample Answer
Table 6: Activity schedule for the seven activities of the project
Latest
Finish
EF
7
9.3
16
16.5
25.8
25
33.6
LS
0
77
6.7
7
7.8
16
17.3
25.8
LF
7
16
16
O
17.3
25.8
25.8
33.6
Slack
(LS-ES)
0
9.3
0
0.8
0
0.8
0
Sample Answer
P
Variance
(rounded to 2
decimal places)
0.1100
1.7800
0.4400
1.3600
0.6900
0.2500
0.6900
Is the Activity
Critical?
Yes
No
Yes
No
Yes
No
Yes
O
R
S
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education