write a formula in cell F54 to compute the probability that the entire project will be complete in 35 days.Screenshotzatttachedthankyou!! 3031323637A B383940414243сFGDDE,FABCE85DEFF88ES00=771616.5Activity Earliest Start Earliest Finish Latest StartG1110EF79.31616.525.825HLS06.777.81617.38.507.83Table 6: Activity schedule for the seven activities of the projectVariance(rounded to 2decimal places)LatestFinishLF7161617.325.825.8I0.2500000.694444SlackNext, 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:J44.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.(LS - ES)09.300.800.8J(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.DAN(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)wwwPWe 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 (whetherthe 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), andthe 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_KApjpyBHE33 (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.3435FG0.11001.78000.44001.36000.69000.2500KDE,FIs the ActivityCritical?YesNoYesNoYesNoLABC(85DEFMES0Activity Earliest Start Earliest Finish Latest Start077168816.525.8NEF79.31616.525.82533.61110Sample AnswerTable 6: Activity schedule for the seven activities of the projectLatestSlackFinishVariance(rounded to 2decimal places)LS06.777.8O1617.325.88.507.83LF7161617.325.825.833.6P0.2500000.694444(LS-ES)000.800.800.11001.78000.44001.36000.69000.25000.6900Is the ActivityCritical?YesNoYesNoYesNoYesQ 424344454647414840495051525354555657585960616263ABEFGD1616.5258Project's VarianceE25.82533.6Project's standard deviationProject's Expected DurationTarget days to completeProbability that the project will becomplete in 35 days.F1617.325.81.931.389233.635G25.825.833.6H00.80I0.69000.25000.6900JYesNoYesKGL25.8MN25.833.6Project's VarianceSample AnswerOProject's standard deviationProject's Expected DurationTarget days to completeProbability that the project will becomplete in 35 daysP0.69001.931.389233.63584.32%YesQRST

Here is the answer for the above problem: The IF function, one of the most commonly used Excel…

Answered: write a formula in cell F54 to compute…

Engineering

Computer Science

write a formula in cell F54 to compute the probability that the entire project will be complete in 35 days.

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

See similar textbooks

Related questions

Q: Create a yellow button named btnPush containing the word “PUSH”.

A: Creating a button with yellow color 1. Click on the New Project button to start a new program. 2.…

Q: methods are the The manoeuvre The vertical and slow-move-vertical ones that need to be practised…

A: Given that: What precisely is meant by the phrase "horizontal career shift," and how should it be…

Q: You should start by mastering the moveVertical and slowMoveVertical techniques. Learn how to use the…

A: public class Picture{private Circle hill;private Square wall;private Square window;private Triangle…

Q: 4. Temperature Project 1) Create an Android Project named Temperature Project, that converts the…

A: I attached your answer below.

Q: Android Studio: Relative layouts are the newest and most flexible layout manager. They reduce the…

A: Given: Android Studio: Relative layouts are the newest and most flexible layout manager. They…

Q: You should start by mastering the moveVertical and slowMove Vertical techniques. Learn how to use…

A: The answer is given in the below step

Q: CLIP PERMANENTLY DELETES ALL OF THE CLIPPED LINES. (T/F)

A: I have given an answer in step 2.

Q: Upload the code that will display if the user won or lost the round of hangman. should also prompt…

A: # Problem Set 2, hangman.py# Name: # Collaborators:# Time spent: # Hangman Game#…

Q: Print natural numbers from 1 to 50 using Swift language. Note: All the numbers should be printed in…

A: Write a program in swift language to print natural numbers from 1 to 50 in same line without any…

Q: Visit the following webpage: https://archive.org/details/National_Geographic_Wallpapers This webpage…

A: Google's Vision API is a machine-learning-based technology that analyzes images and offers a wide…

Q: Complete this TODO by finishing the subplot of box plots using Seaborn and Matplotlib. Use the below…

A: Here's the completed code:…

Q: create the Hangman Game using Java FX application.

A: You'll need to create the Hangman Game using Java FX application.

Q: Python question please include all steps and screenshot of code. Also please provide a docstring,…

A: SOLUTION- I have solved this problem in python code with comments and screenshot for easy…

Q: you make a change to a razor layout, the change will automatically affect all the views that use it

A: Defined the statement true for the given statements

Q: Create a web page which contains four links. These links are NOT underlined when user opens it. When…

A: HTML CODE: <!DOCTYPE html> <html> <head> <style> /* Adding property to…

Q: Upload the code that will display if the user won or lost the round of hangman. It should also…

A: #include<iostream>#include<conio.h>#include<string.h>#include<stdio.h>#inclu…

Q: https://drive.google.com/file/d/1WvadErM-1ffp8gm2LcdqdMrtZ0gv3fJv/view?usp=sharing here is my code…

A: The given below is code of the modification of the given code given in the google drive link. The…

Q: In Form Design view of the ParticipantEntry form, write a procedure attached to the On Load event…

A: The global spellcheck attribute tells a browser whether or not to check the spelling/grammar of the…

Concept explainers

Control structures

Control structures are block of statements that analyze the value of variables and determine the flow of execution based on those values. When a program is running, the CPU executes the code line by line. After sometime, the program reaches the point where it has to make a decision on whether it has to go to another part of the code or repeat execution of certain part of the code. These results affect the flow of the program's code and these are called control structures.

Switch Statement

The switch statement is a key feature that is used by the programmers a lot in the world of programming and coding, as well as in information technology in general. The switch statement is a selection control mechanism that allows the variable value to change the order of the individual statements in the software execution via search.

Question

write a formula in cell F54 to compute the probability that the entire project will be complete in 35 days.

Screenshotz

atttached

thank

you!!

30
31
32
36
37
A B
38
39
40
41
42
43
с
F
G
D
D
E,F
A
B
C
E
8
5
D
E
F
F
8
8
ES
0
0
=
7
7
16
16.5
Activity Earliest Start Earliest Finish Latest Start
G
11
10
EF
7
9.3
16
16.5
25.8
25
H
LS
0
6.7
7
7.8
16
17.3
8.50
7.83
Table 6: Activity schedule for the seven activities of the project
Variance
(rounded to 2
decimal places)
Latest
Finish
LF
7
16
16
17.3
25.8
25.8
I
0.250000
0.694444
Slack
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:J44.
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.
(LS - ES)
0
9.3
0
0.8
0
0.8
J
(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.
DAN
(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)
www
P
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
F
G
0.1100
1.7800
0.4400
1.3600
0.6900
0.2500
K
D
E,F
Is the Activity
Critical?
Yes
No
Yes
No
Yes
No
L
A
B
C
(
8
5
D
E
F
M
ES
0
Activity Earliest Start Earliest Finish Latest Start
0
7
7
16
8
8
16.5
25.8
N
EF
7
9.3
16
16.5
25.8
25
33.6
11
10
Sample Answer
Table 6: Activity schedule for the seven activities of the project
Latest
Slack
Finish
Variance
(rounded to 2
decimal places)
LS
0
6.7
7
7.8
O
16
17.3
25.8
8.50
7.83
LF
7
16
16
17.3
25.8
25.8
33.6
P
0.250000
0.694444
(LS-ES)
0
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?
Yes
No
Yes
No
Yes
No
Yes
Q

42
43
44
45
46
47
41
48
40
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
A
B
E
F
G
D
16
16.5
258
Project's Variance
E
25.8
25
33.6
Project's standard deviation
Project's Expected Duration
Target days to complete
Probability that the project will be
complete in 35 days.
F
16
17.3
25.8
1.93
1.3892
33.6
35
G
25.8
25.8
33.6
H
0
0.8
0
I
0.6900
0.2500
0.6900
J
Yes
No
Yes
K
G
L
25.8
M
N
25.8
33.6
Project's Variance
Sample Answer
O
Project's standard deviation
Project's Expected Duration
Target days to complete
Probability that the project will be
complete in 35 days
P
0.6900
1.93
1.3892
33.6
35
84.32%
Yes
Q
R
S
T

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

Tablet Element Styles The page body has four children: the header, the footer, the article element, and the aside element. The article and aside elements will share a row with more space given to the article element. Set the growth, shrink, and basis values of the article element to 2, 1, and 400 pixels. Set those same values for the aside element to 1, 2, and 200 pixels.
Sorry if I want the code read the numbers straight from the file, what should I do? or change. plz also provide a screenshot. thank you
Apply conditional formatting to the selected cells so cells with the 10 lowest valuesare formatted with green fill and dark green text in Excel.
Please dont add in html script but use coding should be in jscript code. It shouldnt be prompting message or alert or console log but it should errorflag the error like the card is valid or the card is invalid when i click the purchase button. Modulus Check Logic For this project, we will be taking in 10 digit credit card numbers. Ensure the user entered only 10 numbers. If they pass this check, perform a modulus check to ensure that the user has submitted a valid credit card number. Note that the checking factors below are the literal checking factors you will use in your solution. Sample Credit Card Number 9434578423 Checking Factors 432765432 Multiply Checking Factors by Credit Card digits and Sum (9 * 4) + (4 * 3) + (3 * 2) + (4 * 7) + (5 * 6) + (7 * 5) + (8 * 4) + (4 * 3) + (2 * 2) = 195 Divide the Sum by 11 195 / 11 = 17, gives a remainder of 8 Subtract 11 - 8 = 3 (this is the check digit) Compare the check digit to the last digit in the…
Write the converse, inverse, and contrapositive of the following statements- If today is Sunday, then it is a holiday. If 5x – 1 = 9, then x = 2. If it rains, then I will stay at home. I will dance only if you sing. I will go if he stays. We leave whenever he comes. You will qualify for GATE only if you work hard. If you are intelligent, then you will pass the exam.
What are these definitions?
In cell A6, output the average of A1 to A5
The manoeuvre The vertical and slow-move-vertical methods are the ones that need to be practised initially. To move the circle to a place that is 70 pixels to the left of where it is now located in your document, use the moveHorizontal command.
Rstudio app using the diamonds dataset, write in the line below the code necessary to make sure that only the diamonds (observations) with carat bigger or equal to 0.3 and cut equal to ideal are included in the dataset. what's the code
The moveVertical and slowMoveVertical strategies should be practiced first. Use the moveHorizontal command to 70 pixels to the left of the current position of the circle in your document.
Event Listeners Return to the mas_register.js file in your editor. Directly below the initial comment section, insert an event listener for the window load event. Run an anonymous function in response to the event containing the following commands: Call the calcCart() function (which you will create shortly.) Create an onclick event handler for the regSubmit button that runs the sessionTest() function when the button is clicked. Create onblur event handlers for the input boxes with the ids: fnBox, lnBox, groupBox, mailBox, phoneBox, and banquetBox, running the calcCart() function in response to each event. Create an onchange event handler for the sessionBox selection list, running the calcCart() function when the selection list is changed. Create an onclick event handler for the mediaCB check box, running the calcCart() function in response. JavaScript Functions Create the sessionTest() function. The purpose of this function is to provide a validation test for the conference session…
It is not a graded question. It is a practice question from last year. I'm stuck please help! Question You should be able to do this question after learning about how to display text and learning howto write a basic counting loop.Use a counting loop to draw the eight buttons on the top button bar. Create appropriate globalconstants to specify the width and height of the buttons as well as the number of buttons. Thisloop should draw buttons with no text labels on them. You can choose whatever fill colour youwant for the buttons.Next, add the text labels [New…, Original, UPPER, lower, iNVERT, camelCase, CONSTANT]to the buttons, one at a time1. You can’t do this inside the loop because each label is unique. Youcan create functions to draw each button label if you want. All the labels should be verticallyaligned and each label should be centered in each button. The buttons should follow the ordershown. There is no label for the last button (that’s for the bonus).Finally, add code to the…