I developed an MS-Excel utility recently for selecting a random sample. This utility takes the population size and sampling percentage as inputs and generates a random sample from a larger set of observations (population).
This utility runs over an MS-Excel VBA Macro. The sub-routine within the VBA Macro makes use of Randomize and Rnd functions to generate random numbers.
Click here to download the MS-Excel Random Sample Selector.
This utility runs over an MS-Excel VBA Macro. The sub-routine within the VBA Macro makes use of Randomize and Rnd functions to generate random numbers.
Click here to download the MS-Excel Random Sample Selector.
No comments:
Post a Comment