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.
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!
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.
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!
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.
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.
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.
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.
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!
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.
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.
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!
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.
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.
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.
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
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.
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.
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.
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.
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.
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
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.
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
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.
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!
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.
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.
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.
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.
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.
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.
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.
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.
***** 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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.
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!
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.
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.
Michelle Robinson I agree. I like seeing it from the beginning because it makes more sense.
+Michelle Robinson I agree. It made more sense and I could follow along better.
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.
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.
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.
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.
Please how do I generate and concealed random number?
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!
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.
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.
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!
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.
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.
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.
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
Certainly I have been unaware of the tremendous tool excel is until I started watching these videos.
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.
Jacklin Skibicki Still a bit technical for me but I could follow the step.
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.
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.
This video was most helpful because he started off from scratch! It allowed me to follow along and go with him step by step.
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.
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.
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
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.
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
Excel is a very useful tool indeed and this informative video will make it easy to generate random samples and analyze statistics when needed.
I don't know SPSS, but excel is much easier to follow.
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.
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!
Mandy Moore Yes, agreed! I never knew how to generate random numbers in excel before. This video was interesting in learning that.
This was helpful in showing me how to look for random sampling and draw scenarios that apply to the information.
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.
I agree Jasmira. Excel is a very effective tool.
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.
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.
Ashlee Todd yes ashlee i agree.
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.
Candace Fernandez Agreed! The step by step demonstration was helpful!
Candace Fernandez yes this was super helpful... I have been scratching my head like Ok, how do we set it up from scratch?
That's the same thing I was thinking. I needed to start from the beginning and go through the process.
Candace Fernandez I agree, really useful to follow from scratch!!
I agree that it was helpful to follow him from the very beginning.
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.
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.
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.
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.
***** 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.
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.
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.
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.
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.
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.
Jillian Curtis I agree. I have not used excel in a while, & these videos have been helpful, both for a refresher, & learning new things.
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.
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.
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.
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.
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.
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.
Since I have only learned how to use SPSS, this video was helpful in learning how to set up a data set in Excel
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!
Great! I have been wondering how to build a spread sheet from the ground. This was very helpful to watch that.
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.
Rachel Foster I think it would be a great idea to ask for an example in class! I could use one as well!
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.
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.
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.
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.
Bethany Elstrom I agree it was easy! and yes excel seems less and less daunting with each video.
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.
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.
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.
this video was informative. thank you for sharing . i find it helpful that all this can be done on excel.
Great video , simple and easy to understand.
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.
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.
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.
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.
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.
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.
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.
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.
Thanks so much Todd, your video is very helpful...
great step by step tutorial
Thanks a lot simple and easy to understand
Hello Dr. Grande. Thank you for this video. It was very helpful. Can I also get a normal distribution for a random sample?
Can I analyze the case of Dr Todd Grande helping me with my statistics class?
when I use the rand between function it produces like 10 decimals. I only want integers.. how do I do that?
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.
i think spss is easier than excel
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.
This video had good pacing for following along and administering the steps myself as I worked through the process