Question

Please solve in excel

A robbery has just been committed at the Corner Market in the downtown area of the city. The market owner was able to activate the alarm, and the robber fled on foot. Police officers arrived a few minutes later and asked the owner, “How long ago did the robber leave?” “He left about 9 minutes ago and headed east.”, the owner responded. “He’s probably nine blocks away by now.”, one of the officers said to the other. “Not likely”, said the storeowner. “He was so stoned on drugs that I bet he’s still only within a few blocks of here! He’s probably just running in circles!”

Perform a simulation experiment that will test the storeowner’s hypothesis. Assume the following:

It takes him 1 minute to walk each block (they are short).

At the end of each minute interval he is at a corner. There is a 28% chance that he will fall asleep for 1 minute, and an 18% chance that he walk east, or north, or west, or south.

My suggestion is to run at least 1000 trials of the nine-minute journey of the robber.

What is the probability he is two blocks or less (walking on streets) from the store?

On average how many block has he walked?

On average how far away is he (using blocks-no “diagonals”) from the store?

Answer 1

The problem was modelled on excel as shown below:-

The simulation is run for 100o trials and the notation that if he goes right or north that makes him go 1 block ahead and if he takes south or west that makes him go -1 block back.

The formula sheet is:-

The probability he is two blocks or less from the store is 0.477

Less than 1 block away.