Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.9 minutes and standard deviation of 0.7 minutes. Roy K's 10K finishing time is believed to be uniformly distributed between 34.1 and 37.1 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 linked here: BoxingDay10K Template.xIsx & 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started