Tractors Alt - SIMULATED TRACTOR PRODUCTION Excel generates 10,000 random numbers x between 0 and 1 It then picks Red if 0 <= x < 0.48 White if

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
x Line Starts Number Non-starting Fraction of Total 0.226276 Red yes 777 0.0777 0.493665 White yes 0.698550 Blue yes Number Non-starting Fraction of Non-starting 0.134011 Red yes Red 0.742644 Blue yes 295 0.3797 0.131236 Red yes White 0.299194 Red yes 235 0.3024 0.536641 White yes Blue 0.499562 White yes 247 0.3179 0.933425 Blue yes 0.438624 Red yes 0.035211 Red yes 0.839508 Blue no 0.691072 Blue yes 0.675659 White yes 0.332090 Red yes 0.595765 White yes 0.350825 Red yes 0.923586 Blue yes 0.079671 Red yes 0.257090 Red yes 0.455776 Red yes 0.145573 Red yes 0.522882 White yes 0.199452 Red yes 0.232546 Red yes 0.343118 Red yes 0.591229 White yes 0.271052 Red yes 0.511631 White yes 0.961389 Blue yes SIMULATED TRACTOR PRODUCTION Excel generates 10,000 random numbers, x , between 0 and 1. It then picks Red if 0 <= x < 0.48, White if 0.48 <= x < 0.69, and Blue if 0.69 <= x < 1. If Red is selected, Excel picks "no" with probability 0.06. If White or Blue are selected, then "no" is picked with probabilities of 0.11 or 0.08, respectively. The number of "no's" is counted and divided by 10,000. This is the fraction of non-starting tractors for this simulation. The fractions of non- starting tractors that were made on lines Red, White, and Blue are also computed. Pressing F9 will run a new simulation. Mathema P The Ma © 2007 b The Unive
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
0.848648 Blue yes 0.669476 White yes 0.851470 Blue yes 0.684308 White yes 0.259293 Red yes 0.142048 Red yes 0.497683 White yes 0.707486 Blue no 0.932756 Blue yes 0.476872 Red yes 0.545013 White yes 0.433060 Red yes 0.002616 Red yes 0.418543 Red yes 0.650824 White yes 0.357969 Red yes 0.937087 Blue no 0.698944 Blue yes 0.620508 White yes 0.719698 Blue yes 0.324651 Red yes 0.594870 White yes 0.149367 Red yes 0.842900 Blue yes 0.209294 Red yes 0.247426 Red yes 0.139762 Red yes 0.890549 Blue yes 0.384597 Red yes 0.656626 White no 0.689024 White no 0.534892 White yes 0.042040 Red yes 0.414667 Red yes 0.617089 White yes 0.542349 White yes 0.996111 Blue yes 0.764074 Blue yes 0.439575 Red yes 0.227601 Red yes 0.926746 Blue yes 0.403176 Red yes 0.155513 Red yes 0.208886 Red yes
Background image of page 2
0.602817 White yes 0.575531 White yes 0.880107 Blue yes 0.917951 Blue yes 0.344259 Red yes 0.584696 White yes 0.466984 Red yes 0.903088 Blue yes 0.264264 Red yes 0.608573 White yes 0.274136 Red yes 0.352709 Red yes 0.311201 Red yes 0.267390 Red yes 0.049609 Red yes 0.006824 Red yes 0.341789 Red yes 0.944267 Blue yes 0.692778 Blue yes 0.144043 Red no 0.194837 Red yes 0.998385 Blue yes 0.855783 Blue yes 0.124915 Red yes 0.568635 White yes 0.823887 Blue yes 0.569662 White yes 0.043654 Red yes 0.932480 Blue yes 0.347577 Red yes 0.787321 Blue yes 0.634516 White yes 0.936754 Blue yes 0.351005 Red yes 0.441000 Red yes 0.666569 White yes 0.223786 Red yes 0.297658 Red yes 0.566427 White yes 0.199617 Red yes 0.156061 Red no 0.977834 Blue yes 0.200100 Red no 0.606586 White yes
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
0.332532 Red yes 0.114670 Red yes 0.308562 Red yes 0.248963 Red yes 0.327968 Red yes 0.874849 Blue
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/02/2008 for the course MATH 115a taught by Professor Ekstrom during the Spring '08 term at University of Arizona- Tucson.

Page1 / 456

Tractors Alt - SIMULATED TRACTOR PRODUCTION Excel generates 10,000 random numbers x between 0 and 1 It then picks Red if 0 <= x < 0.48 White if

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online