{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Tractors Alt - SIMULATED TRACTOR PRODUCTION Excel generates...

Info iconThis preview shows pages 1–7. 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 Document Right 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 Document Right 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 yes 0.095016 Red yes 0.404805 Red yes 0.206372 Red yes 0.398372 Red yes 0.125036 Red yes 0.907861 Blue yes 0.621493 White yes 0.006820 Red yes 0.907183 Blue yes 0.954174 Blue yes 0.567568 White no 0.359569 Red yes 0.818029 Blue yes 0.121447 Red yes 0.208500 Red yes 0.914965 Blue yes 0.537714 White yes 0.622318 White yes 0.022233 Red no 0.516884 White yes 0.618679 White yes 0.428366 Red yes 0.310440 Red yes 0.061766 Red yes 0.048592 Red no 0.457338 Red yes 0.084783 Red yes 0.492290 White yes 0.425439 Red yes 0.048808 Red yes 0.610033 White yes 0.937455 Blue yes 0.283542 Red yes 0.891832 Blue yes 0.580463 White yes 0.453044 Red yes 0.833461 Blue yes 0.439314 Red yes
Background image of page 4
0.316596 Red yes 0.361523 Red yes 0.517019 White yes 0.981347 Blue yes 0.635769 White yes 0.504613 White no 0.087374 Red yes 0.695146 Blue yes 0.517194 White yes 0.845153 Blue yes 0.192374 Red yes 0.106510 Red yes 0.145700 Red yes 0.971978 Blue yes 0.440964 Red yes 0.123061 Red yes 0.912372 Blue yes 0.122746 Red yes 0.303446 Red yes 0.031193 Red yes 0.577730 White yes 0.000422 Red yes 0.089227 Red yes 0.362511 Red yes 0.328169 Red yes 0.407157 Red yes 0.944649 Blue yes 0.293380 Red yes 0.073221 Red yes 0.069510 Red yes 0.676651 White yes 0.271744 Red yes 0.677156 White yes 0.018415 Red yes 0.498583 White no 0.919816 Blue no 0.585415 White yes 0.741417 Blue yes 0.615806 White no 0.281063 Red yes 0.311592 Red yes 0.464519 Red yes 0.201887 Red yes 0.346589 Red yes
Background image of page 5

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

View Full Document Right Arrow Icon
0.023257 Red yes 0.789292 Blue yes 0.608671 White no 0.288932 Red yes 0.455525 Red yes 0.266428 Red yes 0.356956 Red yes 0.030422 Red yes 0.106482 Red yes 0.617012 White
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}