Question: Session 3: Estimation using Normal Distribution in EXCEL May 11 - Aug 11 After attending this week's Wednesday Zoom Session (or watching the session recording),
Session 3: Estimation using Normal Distribution in EXCEL May 11 - Aug 11 After attending this week's Wednesday Zoom Session (or watching the session recording), please respond to this discussion topic which requires you to run a "simulation" in EXCEL (vs. Crystal Ball). The file for running this simulation is attached below. In the Individual Assignment this Session you will run a similar simulation using Crystal Ball and then compare the results against those you got here using EXCEL. The takeaway from the Discussion and Individual Assignment this Session is that, when all distributions are normal, you can use a widely-used and reasonably-priced application like EXCEL to perform "simulations", instead of using a very expensive tool like Crystal Ball (which is beyond the price range of most organizations). Actually, when using EXCEL you are not really doing a simulation. Instead, you are using EXCEL functions to perform a calculation that yields results that are more precise than a Crystal Ball simulation. The reason for this increased precision is based on statistical considerations that we don't need to discuss (because they are beyond the scope of this course.) Remember, however, that a simulation only approximates the correct answer (whereas EXCEL calculates
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
