This video was great! I appreciate that Dr. Grande offered different ways of running the numbers using Excel. There are so many other functions within the program I was not aware of until I began watching these step-by-step guides. Very helpful!
@laurynmoffa
5 жыл бұрын
This video helped me understand random sampling and using random numbers. It helped me understand how to pick a sample size when I actually do have a population of scores for my research assignment. Thank you for creating this very informative video. I can look back on it when I am confused about sampling, rank & percentage, and random number generation.
@tamarabakergibbons5715
5 жыл бұрын
The data analysis tool was straight forward and simple to use. My stats undergrad professor used to say there was no such thing as a random number selection. "Everything runs off a formula. So how could it ever be random?" he would say. Thank you for the video Dr.Grande.
@brittanyhoffman8068
5 жыл бұрын
Thank you for the video Dr. Grande. It's interesting to see how you build an excel sheet by adding random numbers. This is a good tool to use for practicing all the information we've been learning throughout your videos.
@jackiedeleonardis1153
5 жыл бұрын
This is a very helpful function to know how to use and I liked how you started with a blank spreadsheet so we could see how you entered all of the information.
@michellerobinson968
9 жыл бұрын
I appreciated the fact the it started with a blank sheet. It was easier to follow and grasp. I liked that he showed different ways/options to get the random numbers. I believe this is useful when practicing with statistics.
@jhoward1129
9 жыл бұрын
Michelle Robinson I agree. I like seeing it from the beginning because it makes more sense.
@Mjthfdj
9 жыл бұрын
+Michelle Robinson I agree. It made more sense and I could follow along better.
@daniellemaldonado631
9 жыл бұрын
It was great to have Dr. Grande start off with a blank sheet and start from scratch. I could easily follow along with him and do this myself. This is good to know for our papers.
@thecorgisquad9861
9 жыл бұрын
I also really liked being able to see this made from a blank slate, rather than it already being a pre-made set of data already calculated out. I did not know that random number generating was a function in excel, which makes it so easy to run statistics and probabilities on truly random numbers. I also love how excel lets you copy and drag a function once you have computed it in one cell; it saves so much time.
@heather7927
8 жыл бұрын
I like how this video showed alternative ways of obtaining the data analysis worksheet page. I like how it started as a blank page and progressed from there. I appreciated the explanation and the usage of the formulas. This helped to understand it more.
@pearlbutler9377
8 жыл бұрын
I feel the same but feel I need to watch several times to understand the entire video. I understand how to generate the random numbers.
@lizconnor1820
7 жыл бұрын
I never realized that Excel could be used for random sampling and random number generation. This video would be really helpful for the layperson who wants to perform these functions but does not have access to SPSS to do so. This is really helpful and valuable information!
@alexdeloach6472
7 жыл бұрын
I completely agree! I am so much more aware of what I can do in excel and these videos make it easy to follow along in excel with your data.
@deniseswindell2175
5 жыл бұрын
This was helpful in showing me how to look for random sampling and draw scenarios that apply to the information.
@rhondabaileyyy
6 жыл бұрын
This video was most helpful because he started off from scratch! It allowed me to follow along and go with him step by step.
@meganblackwell8600
9 жыл бұрын
I never knew excel had this function of random number assignment. Previously I had used various random selection websites, and I am glad there is a seemingly more legitimate tool I can use.
@ehikioyaeustace8467
4 жыл бұрын
Please how do I generate and concealed random number?
@jhoward1129
9 жыл бұрын
I mentioned in an earlier video that I wondered if Dr. Grande made his own templates or if they came from a template. I like that this video started from a blank slate.It is an even better demonstration of how to do something. I also like like copy and drag function because it is definitely a time saver. Good tip!
@virginiamurrey9139
6 жыл бұрын
I enjoyed how there were options on how to get the same data, as everyone learns in different ways. One way may be easy to remember for one person than the other, and this video is a great representation of providing different choices. I also enjoyed that I could follow along step by step through each process.
@robertodonati1037
7 жыл бұрын
I have never used Excel that much, so these videos give me a better understanding of the powerful tool it can be. The video by going step by step it makes it clear to follow and do it yourself on an Excel spread sheet
@remigiusdemby7433
7 жыл бұрын
Certainly I have been unaware of the tremendous tool excel is until I started watching these videos.
@remigiusdemby7433
7 жыл бұрын
These videos have shown how useful excel is in making calculations. Random number generation and random sampling is just another instance to demonstrate the usefulness of excel.
@aussiebreezekorb8877
7 жыл бұрын
Very helpful! Dr. Grande continues to reinforce vocabulary that we have been learning but does not go too slow or too fast for me to understand. Another video I am thankful will be here for me to refer to in the future if needed.
@jillbeck6917
6 жыл бұрын
Excel is a very useful tool indeed and this informative video will make it easy to generate random samples and analyze statistics when needed.
@wardellwhittaker859
6 жыл бұрын
I don't know SPSS, but excel is much easier to follow.
@mandabear52289
9 жыл бұрын
I think this video was helpful in that it helped me understand how to generate random numbers in Excel. I was actaully wondering how to do that in order to practice some of these statistics in Excel. I also thought that it clearly showed exactly what a random sample is. I've always been a fan of random sampling in research so it's nice to know that Excel can do that.
@thecorgisquad9861
9 жыл бұрын
Mandy Moore Until I watched this, I either couldn't remember how to or didn't learn how to generate random numbers in Excel, either! It has been quite some time since I had a statistics class, so this was very helpful to me!
@toniettemorda9077
9 жыл бұрын
Mandy Moore Yes, agreed! I never knew how to generate random numbers in excel before. This video was interesting in learning that.
@jacklinskibicki6098
9 жыл бұрын
This video was really helpful in learning to generate random numbers and how to draw a random sample in Excel. I have no prior experience with this tool pack so this video will hopefully help me to better navigate this function and understand this tool pack system in general.
@reginaames3038
9 жыл бұрын
Jacklin Skibicki Still a bit technical for me but I could follow the step.
@CandyKaneLane
9 жыл бұрын
Jacklin Skibicki I feel as though a lot of us are unfamiliar with the tool pack and how to use the system, I think maybe an in-class demonstration would benefit us, even if he lets us come up to the computer and try it out for ourselves with his guidance.
@bethanyelstrom3566
9 жыл бұрын
Jacklin Skibicki I agree. I had no prior experience with this function in Excel. I found the steps easy to take. I had to load this tool package into my Excel since I did not have it loaded. The best thing for me will be to just start playing with the functions to learn more about the functions.
@susanwilder7616
9 жыл бұрын
Out of all of the videos so far, I was most excited to learn about this function. I can see myself applying it to things outside of school. In regards to the function, it could get frustrating having the data change every time you click on the cell.
@reneemendez4287
9 жыл бұрын
Susan Wilder After watching this video I realized how interesting this was. I thought that a random number generator simply gave you random numbers, but this is some complex! Complex but easy to understand. I really enjoyed this video and learning about this function
@daniellemaldonado631
9 жыл бұрын
Susan Wilder I agree with you Susan, the fact that the cell change would be frustrating. However, having Dr. Grande show us how to stop that was helpful.
@melissaclendaniel9811
9 жыл бұрын
I agree that the concepts in this video are easy to connect to the application of research. I was excited that they video was easier to understand that some of the others
@Mjthfdj
9 жыл бұрын
This was a good step-by-step tutorial. I could easily follow along and really enjoyed it. With this being my first research course, it is nice when I see things done from beginning to end and I don't feel like I have to jump in and catch on somewhere in the middle.
@simonehenry469
9 жыл бұрын
Ashlee Todd yes ashlee i agree.
@amandagerrick5407
7 жыл бұрын
I found this video to be really helpful for myself as well as anyone else who likes to use Excel. These are just two other functions to now know how to use.
@ashleydorsey6745
9 жыл бұрын
This video was helpful in understanding how to build a blank worksheet. I was wondering how to input the formulas leading to the generation of values. I learned how to express random numbers via excel and add values into blank cells.
@jpincinjr
9 жыл бұрын
***** This one will prove very helpful, I think. We'll definitely need to come up with some random numbers at some point in this research class. Maybe even for our research proposal? We'll see.
@melissaclendaniel9811
9 жыл бұрын
I was pleased that I was able to understand the concepts in this video easier than some of the others. I can see myself using this function and applying it to research.
@reneemendez4287
9 жыл бұрын
Before watching this video I admit I scoffed believing that this was an invaluable piece of information because it can be easier getting a random number with an app or a website calculator. I now see how very wrong I was. This video will be another on my saved list because I can see this coming in handy later on. Much better than my random number Iphone app!
@michelemunday7653
8 жыл бұрын
This was really great and valuable information. This jogged some memory bubbles from statistics in under grad and I would definitely refer back to this video when needing to generate random numbers from a data set.
@rebeccameece013
9 жыл бұрын
After watching this video, I feel more comfortable with random number generation in Excel because I couldn't really remember how to do it, if I had done it. It was easy to follow and informative. It will be nice to maybe get an example in class as others have suggested in their posts.
@kimberlykelly386
9 жыл бұрын
This was helpful in familiarizing myself a little more with the Analysis Toolpak. I'm sure it will come in handy to know how to make columns static so that they aren't manipulated when you're working with the random numbers. I thought the random seed function was pretty neat, too.
@cassiemclaughlin9489
8 жыл бұрын
I am new to using Excel for statistics and this video discussed the data analysis took pack which seems to be used to navigate statistics in Excel. I found it useful to be introduced to this. Also just watching the navigation is helpful.
@MrsBobDylan
7 жыл бұрын
I was really interested in this video while watching. I learned a lot about Excel and formulas in high school so this was reminding me of a few things I've already learned. It was a good refresher and easy to understand. It's amazing how many functions Excel has.
@joe1579
7 жыл бұрын
Jillian Curtis I agree. I have not used excel in a while, & these videos have been helpful, both for a refresher, & learning new things.
@angelinastanton7996
6 жыл бұрын
I thought the data analysis tool pack was the most helpful for learning how to quickly calculate random numbers, random sampling, and percentile ranks. The video was easy to follow along with and understand.
@toniettemorda9077
9 жыл бұрын
I always found random sampling to be interesting. This video was great to see how they are calculated and how the numbers changes. Data analysis tool pack, is pretty neat to see how it calculates the data.
@brittanyvodzak9198
9 жыл бұрын
Toniette Morda I agree. I also found it to be interesting! I think it I interesting to see how all of the different functions work.
@CandyKaneLane
9 жыл бұрын
This video was great because I was really looking for something where you started from scratch, a blank slate, that I could follow step by step and even demonstrate on my own excel program in order to better learn and understand random number generation and random sampling. Personally, in terms of research I am a fan of random sampling.
@jacklinskibicki6098
9 жыл бұрын
Candace Fernandez Agreed! The step by step demonstration was helpful!
@danielleduboski9831
9 жыл бұрын
Candace Fernandez yes this was super helpful... I have been scratching my head like Ok, how do we set it up from scratch?
@sherrietilghman2745
9 жыл бұрын
That's the same thing I was thinking. I needed to start from the beginning and go through the process.
@jazzynovy5400
9 жыл бұрын
Candace Fernandez I agree, really useful to follow from scratch!!
@rhondabaileyyy
6 жыл бұрын
I agree that it was helpful to follow him from the very beginning.
@jasmiraross2802
7 жыл бұрын
Excel is very effective when it comes to statistical data calculating and functions are already manipulated within the system for better efficiency. I too agree with how it clearly shows what random sampling is. So many functions to choose from.
@ninastreet4630
7 жыл бұрын
I agree Jasmira. Excel is a very effective tool.
@danielleduboski9831
9 жыл бұрын
Great! I have been wondering how to build a spread sheet from the ground. This was very helpful to watch that.
@aliciazahn1718
9 жыл бұрын
The rank and percentile function was really interesting and seems very useful. This function is good for scale like IQ, which Dr. Grande references, or the Apgar scale. I have to say, I feel like at one point I knew why you would need a group of random numbers but I cannot remember it anymore. It was frustrating to watch the two random number generator functions to keep changing with every change to the worksheet. I have to wonder what the purpose of that is. Finally, the sampling function is very simple but obviously useful. It is wonderful that these types of tools exist now because random generation is difficult without technology.
@E2M5I0L4Y
9 жыл бұрын
Because many of these videos start with graphs or functions already set in the excel sheet, I am not sure if I could complete them on my own from scratch. I enjoyed that this video began with a blank sheet and moved step by step through the reasoning and processes behind the statistics.
@jpincinjr
9 жыл бұрын
Solid video. This one will definitely be useful. I liked the reinforcement of the other skills, like finding the mean and standard deviation and stuff that we've learned before. Putting it in different contexts is helpful for me to be able to comprehend the information.
@E2M5I0L4Y
9 жыл бұрын
Jeff Pincin Like you mentioned with putting concepts in different contexts, the overlap of the concepts in the videos makes research seem more manageable for me.
@sherrietilghman2745
9 жыл бұрын
The data analysis tool pack provides the researcher with powerful tools that can be useful when generating random sample. Having the ability to make the numbers in the data set static, if you like that set and do not want them to change is great.
@briannagoitiandia9833
7 жыл бұрын
Since I have only learned how to use SPSS, this video was helpful in learning how to set up a data set in Excel
@brittanyvodzak9198
9 жыл бұрын
I was wondering how you could do this in Excel. I was attempting to practice in Excel so it is definitely helpful so I did not have to put in my own random numbers. This video was very easy to follow and was extremely helpful!
@zureezee1887
7 жыл бұрын
I had no idea excel has so many functions, interesting how many features are in excel that can be used for random sampling as well as generating random numbers and calculating the mean/averages.
@joseliz8762
5 жыл бұрын
this video was informative. thank you for sharing . i find it helpful that all this can be done on excel.
@jazzynovy5400
9 жыл бұрын
This was an awesome video! Although the video went pretty quick in the steps and I had to rewind a few times, it was very interesting to to follow the video with my own open Excel document. I liked the fact that I could follow and do the steps myself and see in person how it is done.
@rachelfoster5463
9 жыл бұрын
The directions on this work sheet were very good. I had an easier time following what he was saying. I wish he also gave an example of how it is used in a study. I get the idea of it, but I think an example would have solidified it for me. I'll probably ask for an example in class.
@alainavangelder5327
9 жыл бұрын
Rachel Foster I think it would be a great idea to ask for an example in class! I could use one as well!
@rebeccameece013
9 жыл бұрын
Alaina Van Gelder Agreed! The video was easy and nice to watch, but seeing an example will be nice. But, referring to the video was a nice thing to have available.
@tammywitzke6642
8 жыл бұрын
Great video , simple and easy to understand.
@MichaelSmith-jd5ki
9 жыл бұрын
Random numbers can be fun. Excel has a lot of ways of making random numbers, that's for sure. I was wondering how useful this would be until Dr. Grande mentioned some uses in research near the end of the video. I can see now how it might be useful to compare data with a random set of numbers.
@aliciazahn1718
9 жыл бұрын
Michael Smith Interesting thought about how to use random numbers. I would be interested in learning more about the uses of a random data set. I think I learned it a long time ago but it has since left me. It would have been nice to get some extra detail on the practical use of random numbers.
@angelinastanton7996
6 жыл бұрын
I preferred the method of using the data analysis tool pack for generating random numbers and random samples. It was also easy to calculate the percentiles with the data analysis tool pack. It was simple to configure the mean and standard deviation after using the this method.
@alainavangelder5327
9 жыл бұрын
I like how this worksheet started from the very beginning. However, I don't know that I'll remember all of the terminology used. But again, starting with an empty worksheet and filling in the values was helpful.
@bethanyelstrom3566
9 жыл бұрын
I have not used these functions before. This was a simple tool to use to generate random numbers. I like how easy it was to generate a random number between 0-100. I think the best way to understand this process is to play around with Excel.
@ashleydorsey6745
9 жыл бұрын
Bethany Elstrom I have not used the random number generator in Excel before. I never knew such functions were available. Step by step instructions would be helpful in duplicating the table.
@michellerobinson968
9 жыл бұрын
Bethany Elstrom It was easy to generate random numbers. I too think I would grasp this better if I practiced on Excel and saw first hand how to calculate random numbers and sampling.
@meganblackwell8600
9 жыл бұрын
Bethany Elstrom I agree it was easy! and yes excel seems less and less daunting with each video.
@reginaames3038
9 жыл бұрын
Very useful video for someone such as myself who need to see step by step instructions in order to use excel. However, I would need to have these instructions open in order to duplicate what was done.
@mandabear52289
9 жыл бұрын
I too need step by step instructions on how to use Excel. I actaullly hated using it in college and usually avoided it. However, this video I thought was great in demonstrating how to use these functions. Also, it is helpful in that we can use what this video taught us to practice what the other videos taught us.
@rachelfoster5463
9 жыл бұрын
Regina Ames I liked the step-by-step instructions as well. I am not 100% comfortable with Excel, so it is nice to have the instructions laid out for me. However, I also agree that I would not be comfortable doing this without the video opened.
@placidembala
8 жыл бұрын
Thanks so much Todd, your video is very helpful...
@scottmartin7764
8 жыл бұрын
When it comes to Excel I am very bad especially with using the different formulas. This video was very helpful especially since it is built from a totally blank page.
@chelseydavis4989
9 жыл бұрын
This video had good pacing for following along and administering the steps myself as I worked through the process
@wardellwhittaker859
6 жыл бұрын
The only thing that confused me was the "Random Seed". Everything else was clear. Would love a lecture and examples in class to follow along with. That's my learning style.
@c.m.joseph2556
2 жыл бұрын
Hello Dr. Grande. Thank you for this video. It was very helpful. Can I also get a normal distribution for a random sample?
@oliviahylton9430
5 жыл бұрын
I was required to take a Microcomputer Applications class for my psychology degree but we did not go over this particular feature. I was unaware that Excel had a data analysis tab.
@Bapdlg121479
8 жыл бұрын
Thanks a lot simple and easy to understand
@simonehenry469
9 жыл бұрын
great step by step tutorial
@kstark321
Жыл бұрын
Can I analyze the case of Dr Todd Grande helping me with my statistics class?
@dsbvsdvbsd
4 жыл бұрын
when I use the rand between function it produces like 10 decimals. I only want integers.. how do I do that?
@chibuikenzeako4166
8 жыл бұрын
how can you solve this for me. 1,3,6,8,11,13,17,20.... By combining into five numbers like 3,8,11,17,20 or 1,3,8,11,13 etc. No repeating numbers.
Пікірлер: 99