How To Create A Random Sample In Excel (2 Methods!)

No video

How To Create A Random Sample In Excel (2 Methods!)

Рет қаралды 89,774

Күн бұрын

In this tutorial, I will show you how to perform random sampling in Microsoft Excel. Specifically, I will show you how to create a random sample through two methods: using the Data Analysis ToolPak and by using the RAND function.
ONLINE GUIDE
toptipbio.com/...
VIDEO CHAPTERS
00:00 Intro
00:16 What is random sampling?
00:40 My example data
00:51 Method 1: Analysis ToolPak
03:02 Method 2: RAND function
05:24 Wrapping up
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rj...
KZfaq SEO www.tubebuddy....
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

Пікірлер: 18

@StevenBradburn 3 жыл бұрын

ONLINE GUIDE toptipbio.com/random-sampling-excel/

@KimSmith-RESETIHS Ай бұрын

Thank you so much! I'm taking an online statistics class and have no education in how to use excel. Your video is the first one I found that actually helped me.

@evaschoenfeld3186 Жыл бұрын

Thank you so much for making videos. I'd be lost without it.

@musicsang4882 Жыл бұрын

Dear sir. Pls keep uploading such type of vedio. Your vedios help us very much.

@drbrendaleecato8880 Жыл бұрын

Excellent demonstration! Thank you so much

@jessicafong4660 2 жыл бұрын

This was so helpful, thank you!!!

@marylynnhayek3807 2 жыл бұрын

Question: If we know that our distribution is the exponential distribution, and we have the lambda value as = 1/3 , how can we generate 12 samples randomly in excel?

@gwynetheabing2125 Жыл бұрын

this is very helpful. Any way I can get a tutorial sir?

@vishalmesvaniya5055 6 ай бұрын

Thanks 👍🏼

@josephkipkoech5721 Жыл бұрын

I enjoyed

@murraylouw9962 Жыл бұрын

How can we prevent the first method from sampling the same data more than once?

@CosmopolitanXMan Жыл бұрын

Yeah, I immediately thought so when I saw the result of the first method. Imagine if there are two subjects with same values in the Data, for instance Subject 2 has Data value of 100 and Subject 30 has Data value of 100, too. Since Data with value 100 was selected in the random Sample 1, should I include both Subject 2 and Subject 30 into my Sample 1? But now the number of sample becomes 11 instead of 10.