Note for MATH 115A with Professor Wood at UA
Note for MATH 115A with Professor Wood at UA
Popular in Course
Popular in Department
This 6 page Class Notes was uploaded by an elite notetaker on Friday February 6, 2015. The Class Notes belongs to a course at University of Arizona taught by a professor in Fall. Since its upload, it has received 12 views.
Reviews for Note for MATH 115A with Professor Wood at UA
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 02/06/15
Code for building 1 ATM We have worked on building 1 ATM simulation for 1 hour 11 The following code should be in the following cells row 5 is customer 1 row 6 is customer 2 once row 6 is done you can drag it down for all 200 customers Column F was done for you Column G Row 5 IFC5gt60quotquotC5 ROW 6 IFISNUMBERG5 IFG5C6gt607quotquot7G5C67quotquot Column H Rows IFISNUMBERG5D5quot Row6 IFISNUMBERG6D6quot Column I Rows IFISNUMBERG5G5 Row6 IFISNUMBERG6IFG6gtJSG6JSquotquot Column J Rows IFISNUMBERG5ISH5quot Row6 IFISNUMBERG6I6H6 quot Column K Rows IFISNUMBERG50quotquot Rowe IFISNUMBERG6IFI6 G600I6 G6quotquot Column L Row 5 IFISNUMBERG5 F5 Hu Row 6 ZIPISNUMBERG6 F6 HH Column M Row 5 Row 6 Column S Row 5 Row 10 Column T Row 5 Row 10 Column U Row 5 Row 10 Column V Row 5 Row 10 Column W Row 5 Row 10 Column X Row 5 Row 10 Column Y IFISNUMBERG5IFK5gt5quotyesquot quotn0quotquotquot IFISNUMBERG6IFK6gt5quotyesquot quotn0quotquotquot COUNTGSGZO4 IFSlOquotquotquotquotSUMSlOS35 SUMK5K204 IFT10quot quotSUMT10T35 MAXK5K204 IFU10 quot SUMU10U35 COUNTIFM5M204quotyesquot IFV10 quot SUMV10V35 COUNTIFP5P204quotyesquot IFW10 quotquotSUMW10W35 SUM0520204 IFX10 quot SUMX10X35 Row 5 Row 10 Column Z Row 5 Row 10 Column AB Row 5 Row 10 Column AC Row 5 Row 10 Column AD Row 5 Row 10 Column AE Row 5 Row 10 Column AF Row 10 MAX0520204 IFY10 quot SUMY10Y35 MAXN5N204 IFZIOquot quotSUMZlOZ35 T5SS IFT9quotquotquotquotT9S9 V5 SS IFT9quotquotquotquotV9S9 W5SS IFT9quotquotquotquotW9S9 X5 SS IFT9quotquotquotquotX9S9 IFT9quotquotquotquotZ9COUNTZlOZ35 12 13 14 15 How to find the number of people in the queue customer s number who is arriving person using the ATM number of people in the queue Need to find out who is using the machine when a customer arrives What did we do by hand Looked at the arrival time and compared it to the pervious customer s end of service time counted the difference Same idea here Let excel find the customer who is at the ATM machine when the customer arrives Excel can use the vlookup of end of service times and returns the value of who is at the machine So in columns N O and P type the following It does take into consideration if arrival is before the end of service of the first customer Column N Row 5 IFGSNUMBERG5 O W states no one is at the AT Row 6 IFISNUMBERG6IFG6ltJ51VLOOKUPG6J5L631quotquot if arrival is less than end of service of rst customer returns a 1 or returns customer using ATM Column 0 Finding how many is in the Queue when the customer arrives ROW 5 IFISNUMBERG50quotquot ROW 6 IFISNUMBERG6L6 N6quotquot Column P States if person is irritated IFISNUMBERG5IFOSgt3quotyesquot quotnoquotquotquot IFISNUMBERG6IFO6gt3quotyesquot quotnoquotquotquot Row 5 Row 6 Remember to drag row 2 down for all 200 customers Now check to see if your values equal the practice one given in class Practice Building 1 ATM 2 This was for one particular inter arrival times and service times We need to generate an interarrival time and service time for each customer Create a duplicate worksheet and call it Building 1 ATM 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 To nd a service time unknown distribution we will prove later we will randomly pick a service time from our Data list using randbetween and vlookup See if you can do this on your own then check with the values below Column D ROW 5 VLOOKUPRANDBETWEEN17634 39SerVice times39A3B76362 ROW 6 VLOOKUPRANDBETWEEN17634 39SerVice times39A3B76362 Now generate an inter arrival time for each customer this is a known distribution we will prove later p1 equottmean solve fort inter arrival time tmeanln1 p where p is the probability rand number Column B and C The mean is located in D3 Row 5 Row 6 RAND D3LN1 B5 RAND D3LN1 B6 When you hit F9 you are generating a possible 1 hour run for the number of customers and what could happen Save and close Now make changes to meet your team data a Make a copy of this file call it 1 ATM team data b Open 1 ATM team data file and open the file that contains your teams data c In 1 ATM team data delete the service time data A3B7636 Now copy your team s service times data both columns count and value and paste it on this worksheet service time Starting in A3 When you get done column A has number 1 though number of service times you were given and column B has the value Write down the location of the data and the number of service times Location of service times data Number of service times Go to worksheet Building 1ATM if you wish you could delete the two practice worksheets In Cell D3 type in your mean time for first hour inter arrival times now the inter arrival times will be based on your mean We need to change the service times it generates since we have changed that Change the rand between1 the number of service times you were given Change the Service times A3B 2 fill in the blank with your location ofservice time last entry Make sure you drag customer 2 row 6 B6D6 down to all 200 customers Now hit F9 to see what one hour might look like We need lots of run hours to see what might happen and we need to record them Copy SSZ5 and paste special in SllZ11 You are recording the results of 1 hour Now hit F9 and see another run Copy SSZ5 and paste special in SlZZ12 each recording place in the row between the last entry Now hit F9 and record this run Do this for 7 recorded runs Hit F9 now you have results of 7 hours Get with your team mates and get their 7 runs Record them until you have 26 runs You will be using 6 or 7 runs from each student depending on how many student are on your team Some people type them other send results on excel and copy and paste 26 runs means 12 year of data Now make a duplicate worksheet now change cell D3 to your second hour mean inter arrival time Hit F9 Now record these results like you did for step 16 20 33 Now your team will submit this R1 AF35 for each of the hours so I can see the results 34 Now your team will make changes to the queue focus file the instructor has mailed to you Follow the directions also sent by your instructor these modifications are similar to what we did here and run the simulation for first hour and second hour Print what is required and submit to your instructor
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'