How to Create a Random Sample in Excel (in 3 minutes!)

Рет қаралды 671,305

Check Your Assumptions

11 жыл бұрын

A 3-minute tutorial that demonstrates how to generate a random sampling of records using Excel.

Пікірлер: 103

@courtneyschwartz3409 2 жыл бұрын

You are AWESOME!!! I am a first time college student re taking applied statistics because I failed the first time. This video was very simple, straight to the point, and is going to save my life! Thank you!

@B2McoNZ 7 жыл бұрын

Just what I was looking for and explained very clearly. Thank you. I now have 500 random records from a list of over 2,000 records.

@pelesimajani8850 10 жыл бұрын

Very helpful in my career! I just watched once and understood, thanks Timothy!

@ejrawson8828 8 жыл бұрын

Simple and all in 3 minutes. Great Job!

@raisibeangela 2 жыл бұрын

You just saved me for my stats assignment. Thanks very much appreciated. Video was very helpful

@thembekileshato7226 2 жыл бұрын

Thank you! This was straightforward and super helpful.

@donnajenkins8774 11 ай бұрын

Great demonstration with clear explanation. Thank you.

@abbiedoherty8440 4 жыл бұрын

this was the most helpful thing i’ve watched thank you so much!!

@Dannielperrez Жыл бұрын

Amazing. I have to use this for a social media report, super helpful!

@LIGHT200700 4 жыл бұрын

Thank you this was very helpful and clear.

@shemekasimpson3567 11 жыл бұрын

THANK YOU SO MUCH!! I watched three videos on how to do this before yours and I was confused... and lost... and lost some more. I get it now..

@ksauafea 7 жыл бұрын

Thank you so much for this! Very helpful.

@rainvar7158 3 жыл бұрын

Thank you for a straightforward and fast video :D

@kerfin 8 жыл бұрын

Awesome! That was a great tutorial; thanks :)

@shannonhussein2455 9 жыл бұрын

THIS HELPED SO MUCH THANK YOU!!!

@StephenBased 9 жыл бұрын

Thanks! Great tutorial.

@loanysaldivar6536 7 жыл бұрын

Thanks for the demonstration!

@susanwatson2095 8 жыл бұрын

Tim for a non excel person you made this simple and easy.

@roberthaddad2754 8 жыл бұрын

+susan watson I am glad tim is a non excel person. That is abnormal

@GalowGobiye 2 жыл бұрын

Thank You so much. It helped me in a stressful situation ❤️🙏

@vijaytalkhandkar7815 6 жыл бұрын

Thank you so much for the Demo. it was so helpful....

@miriamdelrosariovazquezper4415 4 жыл бұрын

OMG! this saved me, thank you soo much!!!

@monicaivy2497 5 ай бұрын

Extremely helpful!! Thank you.

@lorandelko 4 жыл бұрын

super useful, thank you!

@nickygoodfellow5870 8 жыл бұрын

So useful, thanks!

@taffywall 10 жыл бұрын

Thanks that was very helpful!!

@alvinrundora7453 Жыл бұрын

Thank you very much this helped A LOT❤

@drbrendaleecato8880 Жыл бұрын

Thank you. That was very helpful

@AllisonJones2550 4 жыл бұрын

Life saver! Thank you.

@CheckYourAssumptions 3 жыл бұрын

Thank you for the comment!

@willa0273223 2 жыл бұрын

Thank you massively. Couldn't believe this 8 yo video still helped me so much today!

@CheckYourAssumptions 2 жыл бұрын

You're welcome!

@yasirjune69 5 жыл бұрын

Highly appreciated

@rahul11 3 жыл бұрын

Neat & Nice Trick. Working like charm even in 2021 :D And yes, the sort function is still present under the `Data` tab. :)

@apputaiparambil 3 жыл бұрын

Thank you. Simple n crisp

@CheckYourAssumptions 3 жыл бұрын

You are welcome 😊

@FullGalvanized 10 жыл бұрын

Thank you Timothy!

@vajnaistvan6035 3 жыл бұрын

Effective, pointing to target, great thx!

@CheckYourAssumptions 3 жыл бұрын

You're welcome!

@alethiagonzalez3350 9 жыл бұрын

THANK YOU SO MUCH!!!!

@laulau3641 3 жыл бұрын

BLESS YOUR HEART SIR

@doh3565 10 жыл бұрын

Thank you so much!

@sbinnify 9 жыл бұрын

YAAS! Thank you!

@TheMichaelhearne 4 жыл бұрын

thank you... super fast, super simple... thanks to you lol

@nuwagiraracheal2978 3 жыл бұрын

Thank you. This was helpful

@CheckYourAssumptions 3 жыл бұрын

Glad it was helpful!

@tpcohee 7 жыл бұрын

Thanks! Very easy example! :)

@zarijafary 8 жыл бұрын

awesome, thank you

@deepakpl2304 4 жыл бұрын

Thanks for helping brother

@CheckYourAssumptions 3 жыл бұрын

You are welcome!

@rebeccaholder668 10 жыл бұрын

Thank you!

@antheachristodoulou6917 4 жыл бұрын

Thank you so much

@soumenduchowdhury3212 2 ай бұрын

Great Stuff quick and simple !!

@miajones66 8 жыл бұрын

Thank you!!!

@sasithaspiceexports2500 4 жыл бұрын

Thanks a lot :)

@sissyramos8890 10 жыл бұрын

Super easy!! :)

@drrabab86 8 жыл бұрын

super like and super thanks

@racheloxley5689 2 жыл бұрын

Amazing- just saved my bacon for a MSc thesis

@TheDestabilized 8 жыл бұрын

Thanks!

@capitanespacio2844 7 жыл бұрын

Great!

@UmiArdan 4 жыл бұрын

Thank you

@robertlyons9226 4 жыл бұрын

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@scottmcdonell7549 11 ай бұрын

Just realized In needed this for my kids, randomizing vocabulary and spelling sheets for practice. Unfortunately the paste option on newer versions of Excel for Mac does not look anything like this, and every iteration of paste I could find I could not get it to work.

@naitaawene Жыл бұрын

So one has a choice between sorting highest to lowest or vice versa to pick your sample?

@ehsanmosafarkhani5382 5 жыл бұрын

thanks

@lauratwesigye6009 5 жыл бұрын

I love you very much......hahahaha thanks a bunch

@feisalabdulaziz2675 25 күн бұрын

Brother I have a problem here,I use to bey Jackpot and I wrote down all the matches with their predictions forexample liverpool. 1. X. 2. Arsenal I have 13 matches I listed in that form,What I need is to get a randomized list of predicted results whereby the actual result will also be in my prediction,that means I need many lists,can I use excel for this and how to use?

@carolinamonroy6855 2 жыл бұрын

Would it be ok for the college to ask for volunteers for the focus group? Why or why not? Are there pros and cons for each sampling approach? Which is best and why?

@pavithranravichandiran6720 6 жыл бұрын

Great novel solution!

@Harlem55 Жыл бұрын

Better to use a RAND call in php/mysql. The reason why is because phps RAND call is truely mathmatically random to a factor of probabillity of near infinity. In Excell, the formula they used is broken and the returned values are only random to a low factor of probabillity.

@mariofutura Жыл бұрын

Undefeated

@bgilllruiz810 Жыл бұрын

Has anyone encountered an issue when pasting. I copy and paste values, but I get an error message stating “you can’t paste this here because the copy area and paste….” And don’t know how to bypass it

@HongKong1842 3 жыл бұрын

I found out a problem. Although the rand and rank functions work well on my simple quiz excel sheet (selecting random questions for users), the content change every time when a user only edit an answer field. This is not only annoying but also messing up the answer corresponding to the original question. Is there a way to stop refreshing please? Thanks a lot for comment.

@fakherraza905 Жыл бұрын

Copy and Paste as Value

@franciscotexidor4901 5 ай бұрын

👍🏼

@Okayrl192 2 жыл бұрын

Yes.

@makaujoy Жыл бұрын

Why didn't you sort from the largest to the smallest

@lwisgonzalez9980 5 жыл бұрын

What method of sampling is this called?

@philipkomba5525 5 жыл бұрын

the method for selecting sample size is simple random sampling BUT a technique is called a RAND()

@tabithag.vcrefgtrytiy4241 3 жыл бұрын

How would I do a random sampling from a group of numbers and only return 5% of the numbers?

@CheckYourAssumptions 3 жыл бұрын

Hi Tabitha- Thanks for your question. You would do the analysis the same way (create a rand column and sort by it), but then you'd only use the top 5% of rows. To figure out how many rows make up 5%, multiply the total number of rows in your data by 0.05. So for example, if you have 100 rows of data, 100 x 0.05 = 5, which means you'd only use the top 5 rows. I hope this answer was helpful.

@unclassifiedclips 2 жыл бұрын

2022 yo

@brainlife 2 жыл бұрын

audio issues

@serenemary873 7 ай бұрын

1:58

@theeducatorkojokwadwo6173 3 жыл бұрын

Using a population of 35 women and 10 men. a. Create an excel sheet containing their names and sex b. Create a random sample of 18 people. What does the B mean? Any help?

@umbnmbu4679 3 жыл бұрын

maybe add 13 more digits to each record number, just to make it more confusing

@CheckYourAssumptions 3 жыл бұрын

Haha- my apologies. In retrospect, I probably could have made this easier :) Nevertheless, I hope the video was at least a bit helpful.

@umbnmbu4679 3 жыл бұрын

@@CheckYourAssumptions Thanks for your sportsmanship :) yes the video was helpful.

@eliheaney2102 3 жыл бұрын

Yep...Im going to fail

@CheckYourAssumptions 3 жыл бұрын

Is there anything in particular that you find confusing? Maybe I can clarify.

@hussainsardarulmulk 6 жыл бұрын

Useless ! Can hardly hear it !

@elrincondegloria4194 5 жыл бұрын

I can hear him very well...maybe you should turn on the volume lol

@gerbyherby1516 10 жыл бұрын

Haha, 3 minutes of wasted time! It can be done in 3 seconds, by just using the analysis toolpak.

@muthuicyrus 6 жыл бұрын

how?

@sergioscudieri3585 6 жыл бұрын

cyrusville Step 1: Go into Excel Options 2. Select Add-ins 3. Under that there should be a section called "manage" at the bottom. Select go 4. There will list a few options to add in. Select analysis toolpack. 5. Select data on the ribbon and on the very right side will display "Data analysis." 6. You select that and it will give you the option to display sample numbers from a population in whichever way you desire (one being random)

@bojarneving6847 5 жыл бұрын

No, not wasted - the Toolpack applies sampling with replacement which oftentimes is less useful