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.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

1st Edition

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Chapter11: Building Solutions: Database, System, And Application Development Tools

Section: Chapter Questions

Problem 11TF

See similar textbooks

Similar questions

ObjectiveTo develop a simple database application using modern programming tools.ToolsStudents should use python as their main development platform. They can also choose either one of the database management systems SQLite, MySQL, PostgreSQL, and Microsoft SQL Server.GuidelinesEach student should agree to work with one student from the class as a teammate. Otherwise, the student works alone and gets penalized by getting at most 75% of the project grade. Teams should work independently toward the same project goal. Each team has to prepare a report presenting all the details about the work done and the job division. The number of pages should not pass twenty.Description of the ProjectThe project is to develop a simple university management system. The application should let three different kinds of users to work, namely, the student, the instructor, and the faculty coordinator. Users should have the following functionalities in the system:Faculty coordinator Log in to the system Add…
Salesforce Assignment: You are working in the big MNC in which they have a project name covid portal. Your task is to find out the contact record whose name start with the raj.
Q3:Your company has just acquired a smaller company that sells office automation software. The smaller company's spreadsheet software has a large market share, with many satisfied users (the major reason for the acquisition was that these existing users are potential customers for your company's other products). Unfortunately, no documentation for the spreadsheet software can be found, and the source code is not commented. How would you go about maintaining this software to keep the customers happy?
Problem Statement: A famous product photographer Xavier is in high demand and is being approached by various companies to get their products photographed. Xavier does all of this product shoots at his studio and wants to make sure that he maximizes his returns by covering as many photoshoots in a day as possible. For a product shoot to be conducted, the product first has to be staged and then photographed. He has a team who stages the products and he does the photoshoots. Depending on the product, it takes different amounts of time to stage and varied time to complete the shoot. His team can stage another product in another part of the studio while Xavier is busy with a photoshoot of a previously staged product. Assuming that his team can work on only one product at a time before they move to staging another and Xavier also finishes one product photoshoot before moving to the next, you are expected to help Xavier make best use of his team and his time by deciding the order in which the…
G2 // Write the basic and sub-steps for establishing a car factory project, with an explanation of the connection and the time periods between the steps
E3 In this project, you are asked to independently research and write a short report relating to our discussion on Biofuel Energy. Your topic selection is completely of your choosing, though the report must clearly demonstrate how the subject is relevant to the overall topic of Biofuels. This course presents introductory discussions through module content and our weekly lectures, to enhance this learning it is up to the student to further explore and independently research topics of interest. The goal of this research report is to explore what interests you, and get on paper your ideas about this area of renewables technology. The marking scheme rewards originality and uniqueness of topic selection. Students with same/similar topics will loose significant marks. Plagiarism will result in a 0 mark, and will be dealt with according to Conestoga Academic Integrity policies. As this is a research report, it is important to develop an overview or a thesis statement about the topic you wish…
Find the weighted average.Weighting: 50% Tests, 30% quizzes, 20% projectsScores are percents Tests Quizzes Projects 92 75 100 87 89 85 67 100 92.5 92 95
emaining Time: 1 hour, 23 minutes, 24 seconds. euestion Completion Status: QUESTION 13 Identify the critical path in the following Network diagram and write the total duration required to complete the project. Note: The numbers given in the diagram are days. 11 12 13 10 6. T TTArial 3 (12pt) v T- Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answer 道 F3 F4 F5 F6 F7 F8 14 F9 F10 Pause $ & %23
Fria Lexa Santos, a Grade 11 HUMSS student, together with her groupmates, is currently working on a research paper for her Practical Research 1 class. She has thoroughly read and researched her topic. She gave a proper citation to the authors of the articles that she used. To Fria's dismay, her groupmates just relied on her to do the research, and on their part, they only copied the works of other authors. She poured out her frustration over her group mates and called their attention on Facebook. To finish the group's research and submit it on time, she included her members' copied articles in her research work. She was so relieved that her teacher accepted the output, and it was uploaded in their Facebook Social Learning Group; however, she felt uneasy and guilty about the output submitted. Jhanna Zia Delos Reyes is known in her school as a social butterfly. Everybody likes her, and she has a wide circle of friends. Most of her senior high school acquaintances are updated with her…
s/4491/lessons/4180/slides/31019 合 3.1.2: Entity Relationship Modelling Prev Next Question SAVED Question Training P. Name Visual Basic Visual Basic SOL SOL P Code Instructor Dennis Dennis Term 15-1 15-2 15-1 15-2 15-1 Duration (Hrs) Hourly Rate 20 Room NO P1 A1 P1 P2 P2 P3 30 A2 Jason 10 20 30 A4 Jason Joneph Joseph Rys A5 P3 P4 C.. Java 15-2 15-2 20 10 A3 A7 A9 6 Identify the most suitable primary key for the table above and explain how this key uniquely defines all other attributes. Baragraph BIU > 8 E E Submit
Create a rudimentary block diagram of a personal computer (PC). Use the introduction section of https://docs.nomagic.com/display/SYSMLP190/Defining+Blocks+in+Block+Definition+Diagram as a guide. You do not need to go into the same level of detail, but try to include as many of the major components found in a PC as possible. You can utilize any tool you choose (MS Word, PowerPoint, Visio, etc.). Your assignment should only encompass a single page
Please use this project link below to answer the questions above thoroughly Software Development Risk Management Model- a goal-driven approachhttps://www.google.com/url?sa=t&source=web&rct=j&url=https://d-nb.info/1011414708/34&ved=2ahUKEwin18bR6Lb9AhWrUjABHQHiDtIQFnoECBAQAQ&usg=AOvVaw0vmiH-3fSabjozkKO5TIaj