Real Statistics Excel Functions: The Real Statistics Resource Pack provides the following useful array functions that allow you to avoid the complex syntax described above. Observation: If we wanted to generate a sample of size 6 with replacement, we would use the following formula in cell C4 instead (column B would not be necessary): See Built-in Excel Functions and Table Lookup for more information about the INDEX function. This will place the formula =RAND() in every cell in the range B4:B23.įinally create column C by putting the following formula in cell C4 and then copying it down (using Ctrl-D as described above) for as many rows as you want items in the sample. Simply enter =RAND() in cell B4 and then highlight the range B4:B23 and enter Ctrl-D. These are generated using the Excel function RAND(). Column B consists of random numbers between 0 and 1. We accomplish this by creating a worksheet as in Figure 2.įigure 2 – Creating a random sample without replacementĬolumn A consists of the data elements in the population (as taken from Figure 1).
HOW TO USE XLMINER ANALYSIS TOOLPAK TO RANDOM GENERATOR HOW TO
We now show how to create the Group 1 sample above without duplicates.Įxample 2: Recreate Group 1 from Example 1 without allowing any duplicates. As you can see from the example, the number 2 is chosen twice in the Group 1 sample.Īs a result, it often better to use other approaches to create a sample.
0 kommentar(er)
