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

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/random-sampling...
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.z6rjha.net/c/198849...
RUclips SEO www.tubebuddy.com/SHTeach
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.

[@StevenBradburn]

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.

[@drbrendaleecato8880]

Excellent demonstration! Thank you so much

[@evaschoenfeld3186]

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

[@jessicafong4660]

This was so helpful, thank you!!!

[@musicsang4882]

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

[@vishalmesvaniya5055]

Thanks 👍🏼

[@josephkipkoech5721]

I enjoyed

[@gwynetheabing2125]

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

[@marylynnhayek3807]

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?

[@Afradillah77]

Ketika saya menggunakan fitur analisis data, muncul angka yang duplikat

[@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.

[@serenemary873]

3:37

[@CCSBeltrano]

THE CC function is notr identrifying the correct text with the video dialogue. Good video otherwise :)

[@Aryanjzwallll]

Assignment 😭

[@rajeshhkkapoor8549]

you guys make it too confusing