fm3_chapter29

fm3_chapter29 - Page 746 Page 1 USING EXCEL'S RAND()...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Page 746 Page 1 USING EXCEL'S RAND() FUNCTION 0.6311 0.0105 0.5600 0.4170 #MACRO? 0.4734 0.1099 0.1766 0.9978 0.6131 0.0674 0.0627 0.8681 0.1377 0.5593 0.9060 0.2582 0.7466 0.3656 0.9124 0.0143 0.3464 0.8546 0.7130 0.2578 0.7525 0.8861 0.8440 0.0735 0.1623 0.0375 0.8683 0.6063 0.8966 0.0578 0.7354 0.3044 Each cell contains thefunction Rand(). Each time you update the spreadsheet or press F9 the block of cells will produce a new set of randomnumbers. A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 List 0.04535 0.41403 0.86262 0.79048 0.37354 0.96195 0.87145 0.05624 0.94956 0.36402 USING VBA'S RND FUNCTION TO PRODUCE A LIST OF RANDOM NUMBERS A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 UN-18B Bin Frequency 0.3097 #MACRO? 0.1 0.6707 0.2 1 0.6864 0.3 1 0.2766 0.4 1 0.1657 0.5 #MACRO? 0.8713 0.6 1 0.5085 0.7 3 0.8267 0.8 0.9062 0.9 2 0.6706 1 1 USING EXCEL'S FREQUENCY FUNCTION TO TEST THE DISTRIBUTION OF RAND() Random numbers Each cell in the range A3:A12 contains the formula Rand() . Pressing F9 will produce a new set of random numbers and frequencies. A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Uniformly Distributed Random Numbers Runs 1,000,000 Starttime 17:37:03 Bin Output Stoptime 17:37:04 1 100,070 Elapsed 0:00:01 2 100,659 3 99,652 4 99,765 5 100,001 6 99,832 7 99,812 8 99,854 9 100,234 10 100,121 Graph title Frequency Distribution of 1,000,000 runs of VBA's Rnd func 1 2 3 4 5 6 7 8 99,000 99,200 99,400 99,600 99,800 100,000 100,200 100,400 100,600 100,800 Frequency Distribution of 1,000,000 runs of VBA's Rnd ction 9 10 d function Seed 334 0.36654 0.29708 0.85005 0.70653 0.54326 0.65463 0.21992 0.96848 0.35859 0.48999 0.12416 0.72373 0.22022 0.06518 0.94125 0.60034 0.18800 0.25382 0.90571 0.70398 PRODUCING LISTS OF RANDOM NUMBERS Output: Each run different Output: Each run same Note : to see the effect of the "Run Random_Same" button, erase the cells B5:B14. Changing the seed in cell B2 changes the output in column B. A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16-0.89 1.09 Bin Frequency-1.88-3 3 0.59-2.9-0.71-2.8 1 1.11-2.7-1.41-2.6 2 0.72-2.5 2-0.24-2.4 4 1.15-2.3 2-0.35-2.2 4 0.05-2.1 8 0.61-2 7 1.48-1.9 6 0.51-1.8 6-0.8-1.7 9-2.28-1.6 11 0.59-1.5 13-0.51-1.4 19 0.77-1.3 16-1.46-1.2 21-0.38-1.1 17 0.39-1 14-1.81-0.9 22-0.22-0.8 29-2.05-0.7 26 0.01-0.6 28-1.56-0.5 29-1.11-0.4 42 1.34-0.3 40-0.21-0.2 40-0.29-0.1 35 0.02 42-1.75 0.1 50-0.58 0.2 41 2.53 0.3 49-0.99 0.4 38-0.29 0.5 27-1.3 0.6 44 0.29 0.7 29-0.74 0.8 29-1.7 0.9 18 0.26 1 22-0.17 1.1 27-0.26 1.2 16 0.55 1.3 15 1.86 1.4 14 0.5 1.5 19-0.69 1.6 10-0.63 1.7 13-1.03 1.8 8-0.86 1.9 6-3-2-1 1 10 20 30 40 50 60 0.86 2 1 0.68 2.1 8-1.21 2.2 4-0.51 2.3 1 0.59 2.4 2 2.5 5 0.09 2.6 1-0.17 2.7 1 1.56 2.8 0.61 2.9-0.88 3 1 0.07-0.54-0.42 0.32 0.4 1.62-0.69-0.45-1.07-1.45 2.96-2.88-0.39 0.4 1.67-1.05 0.22 1.06 0.9 0.13-0.75 0.95 0.93 1.33 0.03-0.25-0.44-0.99-1.2 0.06-1.4 0.75 2.07 1.17-2.63 0.14-0.11 0.22 0.57-0.82-0.59-0.26 0.22-0.67-0.18-0.66 0.39-0.02-0.36 0.51-1.44 0.38 0.55 1.3 0.11-0.33 1.36 1.49-0.5-0.78 1.071....
View Full Document

Page1 / 630

fm3_chapter29 - Page 746 Page 1 USING EXCEL'S RAND()...

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

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