Page 370 - Excel for Scientists and Engineers: Numerical Methods
P. 370
CHAPTER 15 RANDOM NUMBERS & MONTE CARL0 METHOD 347
The preceding formulas can be combined into a single "megaformula"
=INDEX( Database, MATCH (SMALL( random, ROW()-I ),random, 0))
to produce a more compact spreadsheet, as shown in Figure 15-5.
Figure 15-5. A list of names randomized by using a single "megaformula."
(folder 'Chapter 15 Examples', workbook 'Randomize', worksheet 'By Formula')
Random Sampling by Using Analysis Tools
If you have loaded the Analysis ToolPak Add-In (see earlier in this chapter),
you will see that a command, Data Analysis ..., appears at the bottom of the
Tools menu. If it's not there, choose Add-Ins.. . from the Tools menu and check
the box for Analysis ToolPak; this will install Data Analysis ... in the Tools
menu.
Figure 15-6. The Data Analysis dialog box.
