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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!