When done, close browser tab or window.
Start video.
McGraw Hill red cube logo. Because learning changes everything™
Title screen: Generating a simple random sample with replacement. Copyright ©2017 McGraw-Hill Education. All rights reserved.
Narrator: "This video will demonstrate how to apply Excel's Sampling tool to pull a simple random sample from a data set. This data set lists the 50 states in alphabetical order. A number has been assigned to each state. Excel provides multiple ways of pulling a simple random sample from a data set. We're going to use the Sampling tool here. I go to Data, Data Analysis, and I scroll to Sampling."
Data Analysis is clicked from the Analysis section of the Data tab. The Data Analysis dialog box appears with a list of Analysis Tools. Sampling is selected from the list, which opens a new dialog box.
Narrator: "Let's walk through the dialogue box. The input range will be the numbers, not including the label. Random is what we want to use here, because we'd like a selection of 10 random items from our list in column A. My output range—I'll put in the Sample column here."
With cell C2 selected, fields of the Sampling dialog box are edited: Input Range, $A$2:$A$51; the Random radio button is selected to enter 10 into the Number of Samples field; the Output Range radio button is selected to enter $C$2 to its field.
Narrator: "And I click OK. 10 items from the list have been randomly selected. Note that the Sampling feature uses sampling with replacement. When an item from the list is selected, it is put back into the list, which means every state in the list has a 1 in 50 chance of being selected each time a number is drawn. If you have a large enough data set and you're picking a small enough sample, you're less likely to have duplicates. If you do have a duplicate, what most people do is highlight the duplicate cells, as I have done here."
Cells C3 and C8 are highlighted and contain duplicates for 32 and 26.
Narrator: "Then we run Sampling again, exactly the way that we did before."
Sample 2 is entered into cell D1.
Narrator: "And we change the output range and then run Sampling again. And it generates another list of 10 items that have been randomly drawn from our data set. You then go down the list and pick unique items in the order in which they were selected here to replace the items that are duplicates. So, 40 is a duplicate of itself. Go to 9. And now we have 10 randomly selected items from our population of 50 states. This video has demonstrated how to use Excel's Sampling tool to generate a simple random sample from a data set."
Video has ended.
Described transcript ©2023 McGraw Hill. All rights reserved. No reproduction or further distribution permitted without the prior written consent of McGraw Hill.
Close browser tab or window.