Docstoc

sim with rep avg wait time

Document Sample
sim with rep avg wait time Powered By Docstoc
					           A           B         C            D    E       F         G
1    Hammonsdsport Savings Bank with One ATM
2
3 Interarrival Times (Uniform Distribution)
4 Smallest Value            0
5 Largest Value             5
6
7 Service Times (Normal Distribution)
8 Mean                     2
9 Standard Dev           0.5
10
11
12   Simulation
13
14                 Interarrival Arrival Service  Waiting Service Completion
15      Customer      Time       Time Start Time Time     Time     Time
16          1          3.9        3.9     3.9     0.0      2.5      6.4
17          2          4.9        8.8     8.8     0.0      2.4     11.2
18          3          4.6       13.4    13.4     0.0      2.1     15.5
19          4          3.8       17.2    17.2     0.0      2.5     19.6
20          5          0.5       17.7    19.6     1.9      1.3     20.9
21          6          4.0       21.7    21.7     0.0      2.0     23.6
22          7          1.2       22.9    23.6     0.8      2.5     26.1
23          8          1.5       24.4    26.1     1.7      2.4     28.5
24          9          1.9       26.3    28.5     2.2      1.9     30.4
25         10          3.9       30.1    30.4     0.3      0.6     31.1
26         11          2.8       32.9    32.9     0.0      2.2     35.2
27         12          1.8       34.7    35.2     0.5      2.4     37.6
28         13          3.5       38.2    38.2     0.0      3.0     41.2
29         14          1.6       39.8    41.2     1.5      1.4     42.6
30         15          2.0       41.8    42.6     0.8      2.1     44.7
31         16          1.5       43.3    44.7     1.4      1.9     46.6
32         17          2.6       45.9    46.6     0.7      2.1     48.8
33         18          0.6       46.5    48.8     2.3      2.1     50.9
34         19          0.4       46.9    50.9     4.0      2.1     53.0
35         20          3.2       50.1    53.0     2.9      2.0     55.0
36         21          2.8       52.9    55.0     2.1      2.1     57.1
37         22          2.0       54.9    57.1     2.2      1.7     58.8
38         23          1.1       56.0    58.8     2.8      2.4     61.2
39         24          3.3       59.3    61.2     1.9      1.7     62.9
40         25          2.4       61.7    62.9     1.2      1.8     64.7
41         26          3.2       64.9    64.9     0.0      1.9     66.7
     A         B          C          D           E        F       G
42   27       3.9        68.7       68.7        0.0       2.2   70.9
43   28       2.1        70.8       70.9        0.1       2.0   72.9
44   29       2.4        73.2       73.2        0.0       2.0   75.2
45   30       2.3        75.6       75.6        0.0       1.7   77.2
46
47        Summary Statistics                                    In cell D58 enter = E50.
48        Number Waiting                             19
                                                                Highlight C58:D308, Data | Table | lea
49        Probability of Waiting                0.6333          input, then OK.
50        Average Waiting Time                     1.04
51        Maximum Waiting Time                      4.0         Freeze cells by highlighting C59:D308
52        Utilization of ATM                    0.8617          Use Tools | Data Analysis | Histogram
53        Number Waiting > 1 Min                     13         (relevant input range is D59:D308)
54        Probability of Waiting > 1 Min        0.4333
55
56
57                              Avg Wait Time
58
59                        1
60                        2
61                        3
62                        4
63                        5
64                        6
65                        7
66                        8
67                        9
68                       10
69                       11
70                       12
71                       13
72                       14
73                       15
74                       16
75                       17
76                       18
77                       19
78                       20
79                       21
80                       22
81                       23
82                       24
      A   B   C    D   E   F   G
83            25
84            26
85            27
86            28
87            29
88            30
89            31
90            32
91            33
92            34
93            35
94            36
95            37
96            38
97            39
98            40
99            41
100           42
101           43
102           44
103           45
104           46
105           47
106           48
107           49
108           50
109           51
110           52
111           53
112           54
113           55
114           56
115           57
116           58
117           59
118           60
119           61
120           62
121           63
122           64
123           65
      A   B   C     D   E   F   G
124            66
125            67
126            68
127            69
128            70
129            71
130            72
131            73
132            74
133            75
134            76
135            77
136            78
137            79
138            80
139            81
140            82
141            83
142            84
143            85
144            86
145            87
146            88
147            89
148            90
149            91
150            92
151            93
152            94
153            95
154            96
155            97
156            98
157            99
158           100
159           101
160           102
161           103
162           104
163           105
164           106
      A   B   C     D   E   F   G
165           107
166           108
167           109
168           110
169           111
170           112
171           113
172           114
173           115
174           116
175           117
176           118
177           119
178           120
179           121
180           122
181           123
182           124
183           125
184           126
185           127
186           128
187           129
188           130
189           131
190           132
191           133
192           134
193           135
194           136
195           137
196           138
197           139
198           140
199           141
200           142
201           143
202           144
203           145
204           146
205           147
      A   B   C     D   E   F   G
206           148
207           149
208           150
209           151
210           152
211           153
212           154
213           155
214           156
215           157
216           158
217           159
218           160
219           161
220           162
221           163
222           164
223           165
224           166
225           167
226           168
227           169
228           170
229           171
230           172
231           173
232           174
233           175
234           176
235           177
236           178
237           179
238           180
239           181
240           182
241           183
242           184
243           185
244           186
245           187
246           188
      A   B   C     D   E   F   G
247           189
248           190
249           191
250           192
251           193
252           194
253           195
254           196
255           197
256           198
257           199
258           200
259           201
260           202
261           203
262           204
263           205
264           206
265           207
266           208
267           209
268           210
269           211
270           212
271           213
272           214
273           215
274           216
275           217
276           218
277           219
278           220
279           221
280           222
281           223
282           224
283           225
284           226
285           227
286           228
287           229
      A   B   C     D   E   F   G
288           230
289           231
290           232
291           233
292           234
293           235
294           236
295           237
296           238
297           239
298           240
299           241
300           242
301           243
302           244
303           245
304           246
305           247
306           248
307           249
308           250
        H        I   J      K        L        M        N
1
2
3
4
5
6
7
8
9
10
11
12
13
14      Time             FORMULAS FROM RANGE B16:H17
15   in System           B16. =$B$4+RAND()*($B$5-$B$4)
16       2.5             C16. =B16
17       2.4             D16. =C16
18       2.1             E16. =D16-C16
19       2.5             F16. =NORMINV(RAND(),$B$8,$B$9)
20       3.2             G16. =D16+F16
21       2.0             H16. =G16-C16
22       3.2             B17. =$B$4+RAND()*($B$5-$B$4)
23       4.1             C17. =C16+B17
24       4.2             D17. =IF(C17>G16,C17,G16)
25       0.9             E17. =D17-C17
26       2.2             F17. =NORMINV(RAND(),$B$8,$B$9)
27       2.9             G17. =D17+F17
28       3.0             H17. =G17-C17
29       2.8
30       2.9
31       3.3
32       2.9
33       4.4
34       6.1
35       4.9
36       4.2
37       3.9
38       5.2
39       3.6
40       3.0
41       1.9
                  H               I              J               K             L        M   N
       42        2.2
       43        2.1
       44        2.0
       45        1.7
       46
        47
In cell D58 enter = E50.
        48
Highlight C58:D308, Data | Table | leave row input blank and enter B58 for column
        49
input, then OK.
        50
Freeze51 cells by highlighting C59:D308, Edit | Copy | Edit | Paste Special - Values.
       52
Use Tools | Data Analysis | Histogram to create frequency distribution and chart.
       53
(relevant input range is D59:D308)
       54
       55
       56
       57
       58
       59
       60
       61
       62
       63
       64
       65
       66
       67
       68
       69
       70
       71
       72
       73
       74
       75
       76
       77
       78
       79
       80
       81
       82

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:12/19/2011
language:
pages:10