WS 15 – Random Sample Name:
Bootstrapping - Simulation #
This simulation is written for you, run the simulation and modify the file for different information
1. This simulation has been created for you. Read the text and understand the excel file along with
the functions covered in class. Slides 125-134. The text explains this problem and step by step on what
to do. You must understand the file so you can then modifying it to find new results. Hit F9 a few times
to see what is going on. I want you to investigate this excel file. Once you understand the file and what
is in each cell you will know how to answer the questions below.
For some questions you are going to modify this file. Suggestion: create a new worksheet before
making the changes, that are required to the existing file, modify this new worksheet. Make a new
worksheet for each modification. Save your work. This is a strategy you should always do when given a
file from our text.
This is the scenario from the text:
State how you modified the worksheet (if you did) to get the desire results, then
state the results.
A. (i) Use Phone Log.xls to estimate the probability that the last call in a run of 50 calls, starting at
9:00 a.m., will arrive before 10:00am. (No changes in the worksheet)
(ii) Show the probability of 5 different simulations.
(iii) What is the average probability of these 5 simulations?
(iv) Show the probability of 10 new different simulations
(v) What is the average probability of these 10 simulations?
(vi) What is the average probability of all 15 simulations?
(vii) How many total runs when you do 15 simulations?
B. Exercise 17: (i) Use Phone Log.xls to estimate the probability that the last call in a run of 50
calls, starting at 9:00 a.m., will arrive after 10:20 a.m. (ii) Show the probability of 5 different
simulations. (iii) What is the average probability of these 5 simulations.
Your work needs to include what cell(s) you changed and what is now written in the cell(s).
C. Exercise 18 (i) Use Phone Log.xls to estimate the probability that a run of 30 calls, starting at
9:00 a.m., will arrive before 9:30 a.m.
Your work needs to include what cell(s) you changed and what is now written in the cell(s).
Random Sample The operator of a phone switchboard at a large company takes a break
after every 50 calls that he handles. To plan for a backup operator, the office manager would
like to have information on the length of time that it might take for a set of 50 calls to arrive
at the switchboard. Specifically, you would like to know the probability that, starting at
9:00am, a run of 50 calls will arrive before 10:00am.
