Eddie’s Bicycle Shop has a thriving business repairing bicycles. Trisha runs the

Question

Eddie’s Bicycle Shop has a thriving business repairing bicycles. Trisha runs the erception area where customers check in their bicycles to be repaired and then later pick up their bicycles and pay their bills. She estimates that the time required to serve a customer on each visit has a uniform distribution between three minutes and eight minutes.

c. Use Excel to generate 500 random observations and calculate the average. Compare this average to the mean of the service-time distribution.

What is the excel formulas for the service time and average.  

Explanation / Answer

5.339595

Excel formula used for service time is 3+5*rand()

And for average we use average function in excel

Average value of service time of these 500 simulation =

Sno Random number between 3 and 8 1 5.31553 2 7.882606 3 3.869753 4 3.723467 5 5.240622 6 4.565945 7 7.48396 8 3.562936 9 4.347314 10 3.95668 11 4.681595 12 7.013109 13 5.272789 14 5.141041 15 6.567938 16 3.698723 17 5.873184 18 7.783904 19 6.088432 20 6.662592 21 3.342874 22 3.962528 23 7.066811 24 4.5178 25 4.436978 26 6.566771 27 7.925684 28 6.835982 29 5.79326 30 6.899848 31 6.306932 32 3.19866 33 5.004663 34 4.524858 35 6.504346 36 5.010097 37 5.090151 38 3.370768 39 5.636532 40 6.050538 41 3.547099 42 4.63743 43 5.635856 44 4.571673 45 3.917678 46 3.014648 47 5.834713 48 4.171195 49 6.324558 50 7.623305 51 7.606347 52 5.286773 53 5.755486 54 7.37357 55 5.10055 56 4.136732 57 5.643021 58 6.46073 59 7.926501 60 5.124097 61 6.293948 62 6.074471 63 7.277091 64 5.9073 65 5.212744 66 7.68067 67 4.475557 68 4.934683 69 7.275008 70 3.791985 71 4.912024 72 5.1542 73 7.345653 74 7.85577 75 4.64267 76 7.89562 77 6.088068 78 3.097299 79 4.173623 80 6.184317 81 7.367459 82 7.703559 83 7.853668 84 4.259612 85 4.829503 86 5.81504 87 5.362088 88 3.22649 89 7.529122 90 3.396094 91 3.514095 92 3.753034 93 6.244059 94 6.326645 95 4.698855 96 5.534312 97 6.377734 98 3.207905 99 4.088978 100 5.220832 101 7.837581 102 5.249992 103 5.232064 104 4.466583 105 3.654816 106 6.319188 107 4.953846 108 6.629733 109 6.150262 110 4.912776 111 6.985237 112 6.522602 113 4.077555 114 6.292712 115 7.762528 116 6.372115 117 5.294166 118 6.185222 119 6.871139 120 4.071322 121 3.565671 122 4.549759 123 6.977567 124 6.036745 125 5.463778 126 5.224825 127 7.749738 128 3.834216 129 6.294918 130 6.951163 131 7.352988 132 7.021747 133 7.9635 134 3.341123 135 7.241485 136 6.349971 137 6.753628 138 4.736327 139 6.552748 140 4.531671 141 3.592483 142 6.115438 143 7.229036 144 6.100456 145 7.965229 146 3.887638 147 3.408965 148 4.577791 149 7.334703 150 3.600753 151 5.481655 152 3.252157 153 4.399539 154 6.676409 155 6.658581 156 3.24549 157 4.1466 158 3.513111 159 5.513304 160 6.825317 161 6.455051 162 6.441679 163 5.301397 164 7.351013 165 6.707662 166 5.320903 167 6.934618 168 4.684467 169 7.492838 170 7.584857 171 6.952187 172 3.493848 173 4.338251 174 4.221174 175 3.368504 176 4.495633 177 5.083709 178 6.272179 179 3.092471 180 3.537845 181 6.288021 182 3.736195 183 5.448107 184 3.656458 185 3.032091 186 6.612092 187 6.352186 188 4.877986 189 3.427041 190 7.99162 191 4.883074 192 6.866809 193 7.45117 194 4.530426 195 3.555162 196 5.851326 197 3.151275 198 6.106336 199 3.136912 200 3.710494 201 4.935043 202 7.608355 203 7.997141 204 4.632179 205 3.337432 206 3.605619 207 7.050568 208 3.876128 209 5.669347 210 4.054215 211 7.002493 212 6.459247 213 3.799418 214 7.827804 215 4.273688 216 3.808708 217 6.268326 218 5.298414 219 3.169507 220 3.439935 221 4.169563 222 6.02245 223 5.601744 224 3.487634 225 7.250413 226 7.491919 227 6.953979 228 4.211899 229 7.570911 230 7.170863 231 7.227831 232 5.124599 233 7.570918 234 6.125629 235 6.44165 236 5.013189 237 5.261707 238 7.959919 239 7.587046 240 3.287725 241 3.8631 242 4.774814 243 4.007901 244 5.737146 245 3.553815 246 5.102671 247 6.449965 248 3.479031 249 3.385581 250 3.04997 251 7.076785 252 4.779108 253 6.702564 254 6.239482 255 6.801554 256 7.987104 257 6.33495 258 5.004648 259 6.027702 260 4.261213 261 3.805264 262 3.712361 263 3.357329 264 6.933483 265 4.269896 266 3.557191 267 4.18861 268 4.269767 269 6.954937 270 5.772965 271 6.571692 272 3.465399 273 5.707575 274 6.392082 275 7.285912 276 3.567586 277 4.471818 278 7.365461 279 4.883992 280 4.34245 281 3.902706 282 4.262215 283 7.033374 284 4.600592 285 5.664388 286 6.156483 287 4.20646 288 3.928436 289 5.270238 290 6.054789 291 7.083261 292 4.051651 293 6.976558 294 7.523316 295 6.588985 296 7.465693 297 5.321902 298 4.779719 299 6.546747 300 4.980662 301 5.770562 302 7.599267 303 7.900721 304 5.603182 305 5.160841 306 7.955817 307 4.235515 308 7.713873 309 4.507844 310 7.349146 311 4.45911 312 4.247672 313 7.827655 314 4.093166 315 3.929604 316 3.057252 317 7.084962 318 6.685327 319 6.940965 320 3.452817 321 5.800519 322 5.061792 323 4.873446 324 3.564143 325 7.27084 326 6.764255 327 3.637304 328 7.300874 329 6.934187 330 4.498641 331 3.258062 332 5.905696 333 4.349922 334 3.994683 335 3.12416 336 4.805905 337 6.369475 338 3.58656 339 6.52358 340 5.13168 341 6.603754 342 3.204507 343 5.053812 344 6.513448 345 6.04272 346 6.783134 347 6.019871 348 4.685078 349 7.992591 350 5.699509 351 5.384918 352 3.453464 353 7.396716 354 3.496405 355 7.045383 356 7.90757 357 5.298011 358 5.769736 359 4.53481 360 6.106549 361 7.863588 362 6.575089 363 6.849791 364 6.676879 365 6.313466 366 6.739817 367 3.132237 368 6.762424 369 7.199612 370 5.079018 371 4.42683 372 7.816775 373 3.897584 374 6.935231 375 3.122226 376 4.404803 377 5.060797 378 5.598851 379 4.833993 380 3.728452 381 7.787429 382 7.126546 383 3.53025 384 3.699103 385 6.688609 386 5.033016 387 6.431855 388 7.213272 389 5.47466 390 6.483379 391 6.936891 392 6.887424 393 5.225427 394 7.846369 395 4.810755 396 6.053957 397 3.910256 398 6.991683 399 6.356873 400 6.909601 401 4.525355 402 7.462223 403 3.00185 404 7.474538 405 7.854319 406 5.058687 407 6.576141 408 5.842773 409 6.910716 410 7.503618 411 7.878142 412 4.800917 413 5.752472 414 6.610714 415 7.494025 416 5.630979 417 4.501814 418 6.30752 419 3.544946 420 4.764502 421 5.123481 422 3.545914 423 4.298252 424 5.988641 425 7.785568 426 5.834654 427 7.921289 428 6.526223 429 7.104586 430 4.49863 431 4.332991 432 3.628808 433 5.322417 434 5.482772 435 3.971932 436 3.574457 437 5.396689 438 4.037689 439 7.027141 440 7.72076 441 3.857997 442 6.70288 443 5.368194 444 5.406423 445 6.944158 446 3.68023 447 6.339175 448 4.33726 449 3.763281 450 6.428 451 5.948899 452 3.300753 453 5.910567 454 5.031387 455 3.012626 456 5.240003 457 4.070703 458 6.322463 459 6.351046 460 5.565808 461 3.783558 462 6.026042 463 7.276586 464 3.280959 465 5.045249 466 3.512741 467 3.145348 468 4.104871 469 7.394003 470 6.023139 471 4.587819 472 7.724496 473 5.121207 474 3.571007 475 7.986738 476 7.690869 477 6.352707 478 4.272646 479 7.864138 480 4.766835 481 5.467112 482 4.905894 483 7.086819 484 3.663629 485 3.710285 486 7.847896 487 5.36426 488 4.540961 489 4.007442 490 3.665719 491 6.040057 492 4.079875 493 3.138985 494 5.436487 495 4.520468 496 4.138371 497 3.973272 498 5.237065 499 3.705051 500

5.339595

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.