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!
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?
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.
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?
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.
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
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.
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!
Great demonstration with clear explanation. Thank you.
Amazing. I have to use this for a social media report, super helpful!
Thank you! This was straightforward and super helpful.
Thank you massively. Couldn't believe this 8 yo video still helped me so much today!
You're welcome!
Thank you this was very helpful and clear.
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
So one has a choice between sorting highest to lowest or vice versa to pick your sample?
Amazing- just saved my bacon for a MSc thesis
Thank you for a straightforward and fast video :D
Thank You so much. It helped me in a stressful situation ❤️🙏
Thank you. Simple n crisp
You are welcome 😊
Extremely helpful!! Thank you.
this was the most helpful thing i’ve watched thank you so much!!
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?
Neat & Nice Trick. Working like charm even in 2021 :D And yes, the sort function is still present under the `Data` tab. :)
Great Stuff quick and simple !!
Thank you very much this helped A LOT❤
Thank you. That was very helpful
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.
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?
Simple and all in 3 minutes. Great Job!
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..
Thank you so much for this! Very helpful.
To the point.
Many thanks indeed.
Thanks for helping brother
You are welcome!
thank you... super fast, super simple... thanks to you lol
Effective, pointing to target, great thx!
You're welcome!
Thank you so much for the Demo. it was so helpful....
super useful, thank you!
OMG! this saved me, thank you soo much!!!
Life saver! Thank you.
Thank you for the comment!
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
Awesome! That was a great tutorial; thanks :)
BLESS YOUR HEART SIR
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
Thanks for the demonstration!
Thank you so much
Thank you!
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.
What method of sampling is this called?
the method for selecting sample size is simple random sampling BUT a technique is called a RAND()
Thanks! Great tutorial.
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.
Thanks! Very easy example! :)
Thanks a lot :)
Thank you
So useful, thanks!
THIS HELPED SO MUCH THANK YOU!!!
Why didn't you sort from the largest to the smallest
I love you very much......hahahaha thanks a bunch
Thanks that was very helpful!!
Highly appreciated
That was helpful !! Thanks
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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?
Thank you Timothy!
THANK YOU SO MUCH!!!!
awesome, thank you
Thank you so much!
Undefeated
super like
and super thanks
Super easy!! :)
Thanks!
thanks
YAAS! Thank you!
Thank you!!!
Great novel solution!
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!
👍🏼
Yes.
2022 yo
1:58
MT21 🎉😅
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
Thank you. This was helpful
Glad it was helpful!
What method of sampling is this called?
This is a "Simple Random Sample" since each record has an equal probability of being selected.
Thank you!
Thanks!