Question: Please show all work including formulas to put into excel template that is below using the What-If Tool. 13. Each year on Boxing Day (the
Please show all work including formulas to put into excel template that is below using the What-If Tool.
13. Each year on Boxing Day (the day after Christmas), Jamie T and Roy K run a friendly 10K running race. This competition is fierce and both want to win the race. Jamie T and Roy K have been running this annual race for many years, so they have a very good idea of their likely finishing times. However, these finishing times are random. Jamie T's finish time for the 10K race will follow a normal distribution with a mean of 35.4 minutes and standard deviation of 3.7 minutes. Roy K's 10K finishing time is believed to be uniformly distributed between 34.6 and 37.6 minutes Create a Monte Carlo simulation model in Excel that will allow you to estimate the probability that Jamie T will have a faster 10K finishing time than Roy K. Use the Excel template file to build a Monte Carlo simulation model that will estimate the probability that Jamie T. will have a faster 10K finishing time than Roy K. You will need to fill in all the cells shaded in gray to complete the template, but you can add additional calculations if you wish to help you answer this question. What is the probability that Jamie T. will have a faster 10K finishing time than Roy K.? (Enter your answer as a number between 0 and 1, rounded to two decimal places.)

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
