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!
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.
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?
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.
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?
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
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.
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.
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?
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)
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!
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.
You just saved me for my stats assignment. Thanks very much appreciated. Video was very helpful
Very helpful in my career! I just watched once and understood, thanks Timothy!
Amazing. I have to use this for a social media report, super helpful!
Thank you massively. Couldn't believe this 8 yo video still helped me so much today!
You're welcome!
Thank you for a straightforward and fast video :D
Tim for a non excel person you made this simple and easy.
+susan watson I am glad tim is a non excel person. That is abnormal
Great demonstration with clear explanation. Thank you.
Extremely helpful!! Thank you.
Neat & Nice Trick. Working like charm even in 2021 :D And yes, the sort function is still present under the `Data` tab. :)
Simple and all in 3 minutes. Great Job!
Thank you! This was straightforward and super helpful.
Thank you this was very helpful and clear.
Thank you. Simple n crisp
You are welcome 😊
Thank You so much. It helped me in a stressful situation ❤️🙏
Great Stuff quick and simple !!
thank you... super fast, super simple... thanks to you lol
Thank you. That was very helpful
Thank you very much this helped A LOT❤
Amazing- just saved my bacon for a MSc thesis
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.
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..
this was the most helpful thing i’ve watched thank you so much!!
So one has a choice between sorting highest to lowest or vice versa to pick your sample?
BLESS YOUR HEART SIR
Effective, pointing to target, great thx!
You're welcome!
Thank you. This was helpful
Glad it was helpful!
super useful, thank you!
Thanks for helping brother
You are welcome!
Thank you!
Thank you so much for this! Very helpful.
OMG! this saved me, thank you soo much!!!
Life saver! Thank you.
Thank you for the comment!
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?
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.
Awesome! That was a great tutorial; thanks :)
Thank you so much for the Demo. it was so helpful....
Thank you so much
Thanks for the demonstration!
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?
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you
Highly appreciated
Thanks a lot :)
Undefeated
Thanks! Great tutorial.
So useful, thanks!
Thanks! Very easy example! :)
Thanks that was very helpful!!
THIS HELPED SO MUCH THANK YOU!!!
I love you very much......hahahaha thanks a bunch
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
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.
Copy and Paste as Value
THANK YOU SO MUCH!!!!
Yes.
What method of sampling is this called?
the method for selecting sample size is simple random sampling BUT a technique is called a RAND()
Thank you Timothy!
Thank you so much!
Why didn't you sort from the largest to the smallest
YAAS! Thank you!
super like
and super thanks
awesome, thank you
How would I do a random sampling from a group of numbers and only return 5% of the numbers?
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.
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?
Super easy!! :)
thanks
Thank you!!!
Thanks!
Great!
maybe add 13 more digits to each record number, just to make it more confusing
Haha- my apologies. In retrospect, I probably could have made this easier :) Nevertheless, I hope the video was at least a bit helpful.
@@CheckYourAssumptions Thanks for your sportsmanship :) yes the video was helpful.
audio issues
👍🏼
Great novel solution!
2022 yo
1:58
Yep...Im going to fail
Is there anything in particular that you find confusing? Maybe I can clarify.
Useless ! Can hardly hear it !
I can hear him very well...maybe you should turn on the volume lol
Haha, 3 minutes of wasted time! It can be done in 3 seconds, by just using the analysis toolpak.
how?
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)
No, not wasted - the Toolpack applies sampling with replacement which oftentimes is less useful
That was helpful !! Thanks
Thank you!
What method of sampling is this called?
This is a "Simple Random Sample" since each record has an equal probability of being selected.
Thanks!