Problem
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.
Using a Monte Carlo simulation model will help 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.