I love how he shows us in real time on the video what to do in excel. Having something explained or written out can be helpful, but actually seeing him go through all of the steps is a great way to learn how to use this software and then change things or incorporate them into your own work.
What drives this home for me is the example of test scores and what you wanted to do with them. This was clear and very understandable. Definitely a go-to video and one of my favorites.
I really liked that Dr. Grande explained what the "point" means in calculating percentages using excel - made it much more simple to understand! I also very much enjoyed Dr. Grande's inclusion of different ways to "clean up" or organize the data so that everything is clear and precise.
This is helpful! I appreciate the extra short cuts that normally I may not get if I were just to attempt this from using the function wizard. Combining the index with the data analysis really made the chart clearer. Thank you.
I liked that you were able to sort the data from the highest to lowest percentile. It was helpful in actually seeing what was happening. This is also very helpful as a step by step guide.
Using Excel is already confusing to me, so I really appreciate you explaining certain portions of the output like the points and how it is in fact just the participant. Thanks for the step by step process to convert the points to the actual coordinating participant ID.
I definitely feel much more comfortable and less overwhelmed when watching the videos that are using Excel because it is a program that I am somewhat familiar with. I like how detailed this video is and it literally goes step by step. I think this information will be very useful.
Wow, I’m still baffled by all the thing that you can do in excel. I didn’t know that you had the option to calculate the percentiles in excel. This video makes it look easy and I can’t wait to reflect back on it in the future. Thank you!
Dr. Grande, thank you for sharing this. Being someone who uses excel, this was helpful in viewing as i will use this for academic and professional purposes.
I have seen these types of research designs my whole career and often helped to develop new strategies and procedures based on their outcomes. It is interesting to see exactly how those designs were developed.
This is something I think I might be able to do even as an excel newbie. Being able to watch this step by step is so helpful and will be a good resource to watch again if I need to compile data in this way.
Dr. Grande- this information was helpful to understand the percentile rank for participants using Excel. I like how you can see the score and rank on the spreed sheet. Thank you for the easy steps to understand more effectively.
This video was very helpful in learning how to rank participants by their percentile rank. I have never performed this function before in excel, so I am sure I will be visiting this video again!
Wow! This video provides a lot of information that will be useful later in our course. I will certainly return to this video to refresh my memory about calculating percentile rank.
Working in excel previously has been fairly easy for me; however when adding all of these components, and moving past the basics, I will need a bit more practice in understanding and furthering the basics. This video is a great tool for providing me with the understanding I will need.
This was a much simpler video for me to follow. I do think I would need to take copious notes on this video before I would attempt to replicate it, in fear of missing a step or inputting a value. The explanations given for changing columns and re-naming were appreciated!
I like that this video was pretty straight forward and easy to follow. I was happy to learn about percentiles and I can understand a little bit better on how they work. Excel had great and useful functions that will be beneficial to us if we ever have to use them in the future.
This is a great tool to use when comparing how students or any group of people rank for example on test scores. It is clear to see the percent rank function takes those ranks and turns them into percentages.
7 лет назад
great job - clear, gentle, everybody could understand! Thank you very much. We "nonexperts" need more tutorials like this.
Thanks Dr. Grande, I have always wanted to learn how to calculate percentile ranks. I was interested in calculating and comparing the growth of my children.
this video was effective in not only explaining HOW to identify and calculate percentile rank, but also putting into perspective what a percentile rank is. Also, i found these steps very easy to follow and understand.
This video was informative for calculating percentile rank. I found that the point column represents the participants to be confusing at first. Once it was explained and he illustrated how to change the point column to the participants it was understood.
This was one of the most interesting videos I have watched because I can actually understand and replicate what you are doing. This is a very helpful way to rank and get percentile.
Helpful step by step video. I am thankful for the beginning instruction on add-ins. It would have been quite frustrating to follow the subsequent steps without it. It is this attention to detail that makes Dr. Grande's videos so helpful.
So far, it seems as though the add-ins instruction is on multiple videos and that is very helpful. I am hopeful that a demonstration in class is coming soon.
I have never been a fan of using percentile, but it is a very useful measurement and this video shows a very simple way to compute it in Excel. Which I have struggled with in the past.
I very much appreciated watching the step by step calculations; it looks so easy and straightforward. I actually tried following along with this video and doing my own percentile rank calculation and it was not as easy as the video made it look. I had to slow it down a couple paces, and it was easier to follow along with the steps.
Jessica Muzzin After reading your comment, I tried to do that, too. It is a lot harder than the video makes it seem. But the video makes it easier than if I had to go a it by myself from a book or something.
I liked how this video displayed "real world data." It was nice to see how these statistical measurements work together and how they are applied. I like that the video gave me a step by step tutorial on how to run data in excel,which I'm sure I will need to refer back to in the future.
I appreciated seeing how to change point to participant ID. This helped to lessen confusion since participant 6 is actually in row 7. I always like to decrease the possibility of mistakes in reading data!
Dr. Grande, thank you for sharing this step by step tutorial. I feel like this would be helpful in a real like situation where, for example, I would need to compare myself against the performance others. Perhaps, our cohort could find this useful as we take sample tests in preparation for the NCE. We could see where our scores rank in comparison to others.
I found the video very helpful in explaining how to use excel for calculating percentile and appreciate the detailed explanation of how to use the functions in excel.
This video was helpful and easier for me to understand rather than the others. It was simply stated and demonstrated and I feel like I could apply these functions after following along with this video. I can see several applications for this process and feel like it is a very helpful tool to know. Thanks for posting!
This video was pretty straight-forward. I followed it easily, and I can see how useful it is to be able to see the percentile rank of each participant. I also liked how Dr. Grande changed the "point" column to participant ID. I would easily have gotten confused the way it originally was set-up.
Rachel Foster Yes, relabeling is very helpful! He even went as far as to show us how to put the underline back in after bring the participant numbers over to the ranked data set. It looks so easy and clean.
When I first watched this video, I became confused when the columns where being calculated because I knew they would not match the original columns. I was curious as to how to fix this occurrence and was pleased to see that Dr. Grande did explain how this was done. Additionally, I liked how the top row was frozen and it was easy to keep track of each column, I had always wondered how to do that.
Excel is a great tool for statistics and making sense of sets of data. Again, may have to revisit this video once I use the tool but it is a good video with easily understandable information.
This is a great resource for using excel and learning the different coding that needs to be used to represent different tasks such as the $ sign for locking in a column
The more i watch the videos from excel, the more I like it. It is not as clear and concise as SPSS, but it has a lot more functions that I thought it did. I agree that changes the point number to ID was helpful and made it easier for me to follow. I find that a lot of words are used in research that don't necessarily mean the traditional meaning of the word, so that throws me off sometimes.
Very informative video. The text mentions that percentile ranks should not be confused with percentages. The video helped a lot with explaining how to calculate percentile ranks.
Great video, easy to follow. I've learned how to use the data analysis toolpak to rank the scores' percentiles. It's cool to see what seem like complicated functions used to solve apparently simple problems (like cleaning up the spreadsheet with a participant ID column instead of a point column).
It is true that you learn something new every day. Excel has many tools for many different things. Thank you for the lesson on how to calculate percentile rank and also ways to create a clean and organized spreadsheet.
I'm glad Dr. Grande showed how to get the participant numbers over to the data set. I was wondering how that was going to work all the way through the video. Turns out the "index" function is all that is needed. The only issue I have with it seems more complicated to get the participant numbers lined up with the data set than it is to actually get the data into percentile rank! With as many functions that go on in Excel, that's not too surprising, though.
I didn't realize how easy it could be to calculate percentile ranks in Excel. I agree that the column labeled “point” is confusing. I’m glad that there is a way to convert this column to display the correct participant id’s. Everything made much more sense after fixing this.
I had to watch this video twice to gain more of an understanding of the concept. At first it seemed a bit confusing to me also, because it is beyond using the basics of excel, but the second time watching it brought some clarification. it is also a great tool to use as a future reference.
This video is informative in that it demonstrates how to calculate the rank. It is also interesting since it shows how to add and delete data so that labels, such as the point to the participant ID, make it easier to read.
This video helped me to understand and see how easy it can be to calculate percentiles in excel. The video was easy to follow and I can see how this will be helpful in the future.
I like that Excel allows you to sort the data. In this case by the highest percentile to lowest. It is also nice that once you have a formula on a cell you select and drag and the rest is calculated automatically. I sometimes use this for simple calculations.
This is very helpful. Very detailed step by step instructions how to use excel functions.Converting the point data to participants value was very interesting.
This video certainly seems useful in calculating percentile rank and provided helpful instructions that I was previously unaware of, especially shifting the point column to participant ID. This function definitely seems to save a lot of time.
This is also very clear and easy to follow, however, having used SPSS in the past,must feels to me like SPSS is easier but of course Excel is not too complicated. I will need more practice to use excel but I prefer going back to SPSS as I still gave knowledge of its use and can remember more easily. Exactly confusing how the points didn't line up with their respective IDs but after formatting, the various scores points matched with IDs and was easily followed. Another great presentation.
I always find it extremely helpful to learn how to actually utilize the functions of excel to calculate statistics. This video was easy to follow and I believe I would be able to follow these steps should I need to complete this function.
I can definely see how this can be used in a large variety of ways in research. I can imagine sorting all the participants into percentile rank by hand would be very tedious and be subject to error if the person doing it makes a mistake. I also like how Dr. Grande shows how the boxes look without all the correct stuff checked because then if I do it later I know what things to check and what not to.
I think this video was very helpful and easy to follow. Changing the point number to the ID was very helpful. I think Excel has so many different functions that I never knew about so I am glad that I get to learn a lot of them.
Brittany Vodzak I also thought that changing the point number to the ID was helpful. The smallest things in Excel can make a big difference in my understanding the concept. I, too, have learned a lot from Excel.
I have found this video to be very informative. While I understand how to calculate and analyze data using SPSS, I do not have any experience using EXCEL. This was a real eye opener to me.
Another helpful video showing the benefit and ease of utilizing excel for the calculations. I imagine when needed, I would go back to this video and go step by step while using excel.
It is great to have the video to follow in a step by step process. If you miss something, or it doesn't turn out right, he is going through it right there, showing how it is done.
This video shows some great functions of Excel and it also shows a nice clean format for percentile rankings. There is very little that is more confusing than data that is in an impossible to read format.
Thank you for sharing this video Dr. Grande. I am still a little confused about the point. I didn't know that you could use the $ to calculate items as well.
I found this video helpful in that I learned how to do a new skill in Excel. I also think that showing how to change the point number to the participant ID was really helpful. It made the data much easier to read and understand that way,
Mandy Moore Yeah, useful functions. I wonder if there's anybody in the world that understands every function of Excel... That person would have to be crazy smart and understanding of a ton of different things lol
So true Mandy. If the data is not easy to understand, it can make the entire process challenging. This certainly helped, especially in a learning video.
What a time-saver. This kind of stuff could easily take hours without Excel. The way that it populates the percentile rank compared with the score is great and could be very useful.
Jeff Pincin I couldn't imagine doing this manually. This would take days. Plus human error would skew the numbers. I like that Excel populates the information.
Jeff Pincin Agreed! This would be tough to do manually. Luckily Excel would save a lot of time and having this video for instruction is definitely beneficial.
Jeff Pincin making a spreadsheet like this by hand would drive me up the wall and it would take forever. Aren't w lucky to live in this age where it's all point and click?
This is wonderful! I need to get back to using excel and re-learn the functions again so I can stop struggling with stats! This seems a lot easier than calculating everything using a pen and paper. This and the previous videos were extremely helpful!
Angelique Castro I agree, I would never have been able to figure this out on my own. Now if I could only find some time to mess around and practice doing this myself! :)
Robert Roberts Jr. Yes... but excel is really not that hard... it might be until you get the gist of it, but it's quite logic the formulas. I took a couple of computer classes in the past and I remember not having difficulty with it. I haven't used excel in 4-5 years, so I don't remember anything... I need to start messing with it again to remember how to work with it...
This video helped me to better understand percentiles and how useful they can be, especially for schools and students in regards to where they stand academically. The easy step by step excel directions made it easy to follow just how exactly to calculate the percentile ranks.
Candace Fernandez I agree! I found this video to probably be the most straight forward and easy to follow of all the videos we have watched so far. It also made it easy to see how useful having the data ranked by percentile rank can be.
Kimberly Dixon I agree with you, guys. It was straightforward. Also, using plain, easy to understand examples is helpful (we can all relate to scores between 0 and 100!)
I found this video to be really cool. Somehow I never knew the $ locks in the auto fill in the function. I always wondered how high schools did the rank for students in the school. Thanks for sharing.
This was a neat video to see how we can utilize excel for calculating percentile ranks. However, I think I will need to watch this a few more times until I fully grasp it. Percentile ranks confused me through the reading. Watching this seemed to help my confusion, but I need to try to replicate this myself before I really get it.
I appreciate and understand the need for the videos, but for me I am a hands on learner. I get what is being explained...but I won't really get it until I actually have to do it. It was very helpful to get a second explanation other than the textbook.
I actually understood this video much more than the previous ones. Excel can do a lot of calculations and formula if you know how to input the data and make your spreadsheet first. It is still easy to make mistakes and there is always to learn more. I am finding I understand more by continued practice. This was easy to follow and excel will do the work for you. It's trying to get it straight inside my head that is confusing.
So, I was happy with this video because it did not go over my head, at all! I felt like I understood what Dr. Grande was describing and I feel confident that I could replicate it after watching a few more times. It seems if you make a mistake you could easily see where you made the mistake, to go back and fix.
Danielle Maldonado I was happy with this video as well, as it was easier to understand. It is always a good feeling when you feel confident on something you just learned about. I am glad we can refer to these videos because I hadn't known how to do this before.
Although this seems like simple that would be so simple, there are many steps involved and because this is something that I believe get used a lot in research, it probably necessary to understand and have something to reference.
Although I can replicate this, I think I'll need some more practice (and reminders) when/if using this in a real world scenario. I think Excel (and Dr.G) makes these functions look so easy. Actually practicing and using Excel is a different story. I appreciate having these videos handy so we are able to reference when needed! Thank you!
Yea I agree with you Andrew. When I stats in undergrad we learned how to do everything on pen and paper, which is practically useless without learning the software.
Amanda Yarn I agree with you Amanda that I would need a reminder since I don't use this information very often. It is nice to know that these videos are publically available for future access.
Susan Wilder I agree that this video was easy to follow. I liked the index function because it allowed the percentile ranges to be calculated all the way through the data set.
Susan Wilder This was one of the easier videos to follow. I feel more confident about percentile ranks because of this. I was a lot of information though so I think I'd have to save this video for future refrence.
This video makes calculating percentile ranks very clear! I appreciate the step by step explanation as I have previously mentioned, I am not familiar with excel. Although the steps were clearly explained in this video, I am still a tad confused on how to utilize the formula in excel.
I love how he shows us in real time on the video what to do in excel. Having something explained or written out can be helpful, but actually seeing him go through all of the steps is a great way to learn how to use this software and then change things or incorporate them into your own work.
What drives this home for me is the example of test scores and what you wanted to do with them. This was clear and very understandable. Definitely a go-to video and one of my favorites.
I really liked that Dr. Grande explained what the "point" means in calculating percentages using excel - made it much more simple to understand! I also very much enjoyed Dr. Grande's inclusion of different ways to "clean up" or organize the data so that everything is clear and precise.
This is helpful! I appreciate the extra short cuts that normally I may not get if I were just to attempt this from using the function wizard. Combining the index with the data analysis really made the chart clearer. Thank you.
I liked that you were able to sort the data from the highest to lowest percentile. It was helpful in actually seeing what was happening. This is also very helpful as a step by step guide.
Using Excel is already confusing to me, so I really appreciate you explaining certain portions of the output like the points and how it is in fact just the participant. Thanks for the step by step process to convert the points to the actual coordinating participant ID.
I remember this video from research, this is a great refresher for someone who does not use excel to calculate percentile ranks on a daily basis.
I definitely feel much more comfortable and less overwhelmed when watching the videos that are using Excel because it is a program that I am somewhat familiar with. I like how detailed this video is and it literally goes step by step. I think this information will be very useful.
Wow, I’m still baffled by all the thing that you can do in excel. I didn’t know that you had the option to calculate the percentiles in excel. This video makes it look easy and I can’t wait to reflect back on it in the future. Thank you!
Dr. Grande, thank you for sharing this. Being someone who uses excel, this was helpful in viewing as i will use this for academic and professional purposes.
I wish I could apply "There's a function in excel..." to all parts of life. The $ function was new information. Thank you for the video Dr. Grande.
Excel seems to be a great tool for plugging in figures to do calculations. It’s great that you can see each score and rank on the spreadsheet.
I have seen these types of research designs my whole career and often helped to develop new strategies and procedures based on their outcomes. It is interesting to see exactly how those designs were developed.
This is something I think I might be able to do even as an excel newbie. Being able to watch this step by step is so helpful and will be a good resource to watch again if I need to compile data in this way.
Dr. Grande- this information was helpful to understand the percentile rank for participants using Excel. I like how you can see the score and rank on the spreed sheet. Thank you for the easy steps to understand more effectively.
This video was very helpful in learning how to rank participants by their percentile rank. I have never performed this function before in excel, so I am sure I will be visiting this video again!
Wow! This video provides a lot of information that will be useful later in our course. I will certainly return to this video to refresh my memory about calculating percentile rank.
Working in excel previously has been fairly easy for me; however when adding all of these components, and moving past the basics, I will need a bit more practice in understanding and furthering the basics. This video is a great tool for providing me with the understanding I will need.
This was a much simpler video for me to follow. I do think I would need to take copious notes on this video before I would attempt to replicate it, in fear of missing a step or inputting a value. The explanations given for changing columns and re-naming were appreciated!
I like that this video was pretty straight forward and easy to follow. I was happy to learn about percentiles and I can understand a little bit better on how they work. Excel had great and useful functions that will be beneficial to us if we ever have to use them in the future.
This is a great tool to use when comparing how students or any group of people rank for example on test scores. It is clear to see the percent rank function takes those ranks and turns them into percentages.
great job - clear, gentle, everybody could understand! Thank you very much. We "nonexperts" need more tutorials like this.
I'm glad you found this video useful. Thanks for watching.
Thanks Dr. Grande, I have always wanted to learn how to calculate percentile ranks. I was interested in calculating and comparing the growth of my children.
this video was effective in not only explaining HOW to identify and calculate percentile rank, but also putting into perspective what a percentile rank is. Also, i found these steps very easy to follow and understand.
This video was informative for calculating percentile rank. I found that the point column represents the participants to be confusing at first. Once it was explained and he illustrated how to change the point column to the participants it was understood.
This video was extremely helpful and informative on how to arrange data by percentile rank and I can see this being useful in the future.
This was one of the most interesting videos I have watched because I can actually understand and replicate what you are doing. This is a very helpful way to rank and get percentile.
Helpful step by step video. I am thankful for the beginning instruction on add-ins. It would have been quite frustrating to follow the subsequent steps without it. It is this attention to detail that makes Dr. Grande's videos so helpful.
So far, it seems as though the add-ins instruction is on multiple videos and that is very helpful. I am hopeful that a demonstration in class is coming soon.
I have never been a fan of using percentile, but it is a very useful measurement and this video shows a very simple way to compute it in Excel. Which I have struggled with in the past.
I very much appreciated watching the step by step calculations; it looks so easy and straightforward. I actually tried following along with this video and doing my own percentile rank calculation and it was not as easy as the video made it look. I had to slow it down a couple paces, and it was easier to follow along with the steps.
Jessica Muzzin After reading your comment, I tried to do that, too. It is a lot harder than the video makes it seem. But the video makes it easier than if I had to go a it by myself from a book or something.
I did the same thing, i had to slow it down a bit, however, I feel like the more practice I get, the easier it will get.
I liked how this video displayed "real world data." It was nice to see how these statistical measurements work together and how they are applied. I like that the video gave me a step by step tutorial on how to run data in excel,which I'm sure I will need to refer back to in the future.
I appreciated seeing how to change point to participant ID. This helped to lessen confusion since participant 6 is actually in row 7. I always like to decrease the possibility of mistakes in reading data!
This video was informative! Dr. Grande described how to use percentile rank in simple easy to follow steps.
Dr. Grande, thank you for sharing this step by step tutorial. I feel like this would be helpful in a real like situation where, for example, I would need to compare myself against the performance others. Perhaps, our cohort could find this useful as we take sample tests in preparation for the NCE. We could see where our scores rank in comparison to others.
I found the video very helpful in explaining how to use excel for calculating percentile and appreciate the detailed explanation of how to use the functions in excel.
This video was helpful and easier for me to understand rather than the others. It was simply stated and demonstrated and I feel like I could apply these functions after following along with this video. I can see several applications for this process and feel like it is a very helpful tool to know. Thanks for posting!
This was a nice refresher. It was easy to follow and informative when being applied in this manner.
This video was pretty straight-forward. I followed it easily, and I can see how useful it is to be able to see the percentile rank of each participant. I also liked how Dr. Grande changed the "point" column to participant ID. I would easily have gotten confused the way it originally was set-up.
Rachel Foster Yes, relabeling is very helpful! He even went as far as to show us how to put the underline back in after bring the participant numbers over to the ranked data set. It looks so easy and clean.
Rachel Foster Yes, this video was easy to follow compared to some previous videos. This video made it seem user friendly.
This video is helpful, and easy to follow for people who are not too familiar with using Excel in this way.
These videos help me understand how to better use excel. I am somewhat familiar with spss, however this is broadening my horizon.
good refresher and i always appreciate the guided instructions.
When I first watched this video, I became confused when the columns where being calculated because I knew they would not match the original columns. I was curious as to how to fix this occurrence and was pleased to see that Dr. Grande did explain how this was done. Additionally, I liked how the top row was frozen and it was easy to keep track of each column, I had always wondered how to do that.
Excel is a great tool for statistics and making sense of sets of data. Again, may have to revisit this video once I use the tool but it is a good video with easily understandable information.
I am not a skilled excel user so this was extremely helpful in helping explain things in an easy to understand form.
This is a great resource for using excel and learning the different coding that needs to be used to represent different tasks such as the $ sign for locking in a column
The more i watch the videos from excel, the more I like it. It is not as clear and concise as SPSS, but it has a lot more functions that I thought it did. I agree that changes the point number to ID was helpful and made it easier for me to follow. I find that a lot of words are used in research that don't necessarily mean the traditional meaning of the word, so that throws me off sometimes.
Very informative video. The text mentions that percentile ranks should not be confused with percentages. The video helped a lot with explaining how to calculate percentile ranks.
Great video, easy to follow. I've learned how to use the data analysis toolpak to rank the scores' percentiles. It's cool to see what seem like complicated functions used to solve apparently simple problems (like cleaning up the spreadsheet with a participant ID column instead of a point column).
I really liked this video, I definitely understand this a lot better now. I think this is very straight forward and easy to follow, thank you.
It is true that you learn something new every day. Excel has many tools for many different things. Thank you for the lesson on how to calculate percentile rank and also ways to create a clean and organized spreadsheet.
I agree that a clean spreadsheet is very important so that things don't get jumbled and hard to understand.
This was a very easy to follow video and is a great resource to know how to use Excel to calculate percentile rank.
I'm glad Dr. Grande showed how to get the participant numbers over to the data set. I was wondering how that was going to work all the way through the video. Turns out the "index" function is all that is needed. The only issue I have with it seems more complicated to get the participant numbers lined up with the data set than it is to actually get the data into percentile rank! With as many functions that go on in Excel, that's not too surprising, though.
I didn't realize how easy it could be to calculate percentile ranks in Excel. I agree that the column labeled “point” is confusing. I’m glad that there is a way to convert this column to display the correct participant id’s. Everything made much more sense after fixing this.
I had to watch this video twice to gain more of an understanding of the concept. At first it seemed a bit confusing to me also, because it is beyond using the basics of excel, but the second time watching it brought some clarification. it is also a great tool to use as a future reference.
This video is informative in that it demonstrates how to calculate the rank. It is also interesting since it shows how to add and delete data so that labels, such as the point to the participant ID, make it easier to read.
This video helped me to understand and see how easy it can be to calculate percentiles in excel. The video was easy to follow and I can see how this will be helpful in the future.
I like that Excel allows you to sort the data. In this case by the highest percentile to lowest. It is also nice that once you have a formula on a cell you select and drag and the rest is calculated automatically. I sometimes use this for simple calculations.
This is very helpful. Very detailed step by step instructions how to use excel functions.Converting the point data to participants value was very interesting.
Like many of the other videos, seeing how to run the analysis on excel is helpful in understanding the purpose of the analysis
This video certainly seems useful in calculating percentile rank and provided helpful instructions that I was previously unaware of, especially shifting the point column to participant ID. This function definitely seems to save a lot of time.
Jacklin Skibicki I agree. very helpful if we have to calculate percentiles rather than static numbers to present findings
It was good to see this video again. Good refresher from Research
This is also very clear and easy to follow, however, having used SPSS in the past,must feels to me like SPSS is easier but of course Excel is not too complicated.
I will need more practice to use excel but I prefer going back to SPSS as I still gave knowledge of its use and can remember more easily.
Exactly confusing how the points didn't line up with their respective IDs but after formatting, the various scores points matched with IDs and was easily followed. Another great presentation.
I always find it extremely helpful to learn how to actually utilize the functions of excel to calculate statistics. This video was easy to follow and I believe I would be able to follow these steps should I need to complete this function.
Easy to follow. Easy to understand. Very helpful.
I can definely see how this can be used in a large variety of ways in research. I can imagine sorting all the participants into percentile rank by hand would be very tedious and be subject to error if the person doing it makes a mistake. I also like how Dr. Grande shows how the boxes look without all the correct stuff checked because then if I do it later I know what things to check and what not to.
I think this video was very helpful and easy to follow. Changing the point number to the ID was very helpful. I think Excel has so many different functions that I never knew about so I am glad that I get to learn a lot of them.
Brittany Vodzak I also thought that changing the point number to the ID was helpful. The smallest things in Excel can make a big difference in my understanding the concept. I, too, have learned a lot from Excel.
I have found this video to be very informative. While I understand how to calculate and analyze data using SPSS, I do not have any experience using EXCEL. This was a real eye opener to me.
That correct Cheryl.
Another helpful video showing the benefit and ease of utilizing excel for the calculations. I imagine when needed, I would go back to this video and go step by step while using excel.
It is great to have the video to follow in a step by step process. If you miss something, or it doesn't turn out right, he is going through it right there, showing how it is done.
This video shows some great functions of Excel and it also shows a nice clean format for percentile rankings. There is very little that is more confusing than data that is in an impossible to read format.
Thank you for sharing this video Dr. Grande. I am still a little confused about the point. I didn't know that you could use the $ to calculate items as well.
This was good to see again. As I read my comment from before, I still feel the same way. The video is straight forward and informative.
I agree with my previous comment as well
I found this video helpful in that I learned how to do a new skill in Excel. I also think that showing how to change the point number to the participant ID was really helpful. It made the data much easier to read and understand that way,
Mandy Moore Yeah, useful functions. I wonder if there's anybody in the world that understands every function of Excel... That person would have to be crazy smart and understanding of a ton of different things lol
Mandy Moore I agree, for me to use this it would need to meet my needs and having the participant's ID is more useful than a point value.
So true Mandy. If the data is not easy to understand, it can make the entire process challenging. This certainly helped, especially in a learning video.
Cheryl, I agree with you and Mandy! Breaking the data down into "digestible" parts is extremely helpful for researcher and reader.
Hi! Just wanna thank you for your video. Now I know how to use the percentile
Excel is a wonderful tool and I am intrigued by the many functions it performs any time Dr. Grande uses it to calculate one thing or the other.
Remy, I agree. Dr. Grande makes it easy to understand when he creates the videos. I like the step by step process he takes
Thank you for your many contributions Dr. Grande! This was very helpful indeed. E
What a time-saver. This kind of stuff could easily take hours without Excel. The way that it populates the percentile rank compared with the score is great and could be very useful.
Jeff Pincin I couldn't imagine doing this manually. This would take days. Plus human error would skew the numbers. I like that Excel populates the information.
Jeff Pincin Agreed! This would be tough to do manually. Luckily Excel would save a lot of time and having this video for instruction is definitely beneficial.
Jeff Pincin making a spreadsheet like this by hand would drive me up the wall and it would take forever. Aren't w lucky to live in this age where it's all point and click?
i always find excel calculations difficult to follow and thereby appreciate you showing the calculation step by step
Great video and very informative, it's nice to see it done and not read from the book.
Although I do not use Excel much with statistics, I can see how this would be beneficial and something that I would come back to in the future.
This is wonderful! I need to get back to using excel and re-learn the functions again so I can stop struggling with stats! This seems a lot easier than calculating everything using a pen and paper. This and the previous videos were extremely helpful!
I agree that its nice to know that these functions are available! I think the difficulty with that is locating them within the program!
Angelique Castro I agree, I would never have been able to figure this out on my own. Now if I could only find some time to mess around and practice doing this myself! :)
Daniela, I need to start using excel to learn how to use the functions. It is a lot easier but we need to know how to apply the different functions.
I agree Daniela that the videos are helpful. At times it can get confusing, but I keep trying to understand it.
Robert Roberts Jr. Yes... but excel is really not that hard... it might be until you get the gist of it, but it's quite logic the formulas. I took a couple of computer classes in the past and I remember not having difficulty with it. I haven't used excel in 4-5 years, so I don't remember anything... I need to start messing with it again to remember how to work with it...
This video helped me to better understand percentiles and how useful they can be, especially for schools and students in regards to where they stand academically. The easy step by step excel directions made it easy to follow just how exactly to calculate the percentile ranks.
Candace Fernandez Agreed! The easy step by step excel instructions made this alot easier!
Candace Fernandez I agree! I found this video to probably be the most straight forward and easy to follow of all the videos we have watched so far. It also made it easy to see how useful having the data ranked by percentile rank can be.
Mandy Moore I completely agree that this video was probably one of the easiest to follow so far.
Kimberly Dixon I agree with you, guys. It was straightforward. Also, using plain, easy to understand examples is helpful (we can all relate to scores between 0 and 100!)
I like when I have step by step instructions. I can follow that easier and am more likely to understand the function.
Thank you Todd. Very clear and concise. 👌
You are quite welcome -
I found this video to be really cool. Somehow I never knew the $ locks in the auto fill in the function. I always wondered how high schools did the rank for students in the school. Thanks for sharing.
Very useful to figuring out percentile rank and step by step instructions how to do the calculations in Excel.
Jasmine Aviles
yes i agree
This was a neat video to see how we can utilize excel for calculating percentile ranks. However, I think I will need to watch this a few more times until I fully grasp it. Percentile ranks confused me through the reading. Watching this seemed to help my confusion, but I need to try to replicate this myself before I really get it.
This video was very helpful, using excel really decreases the risk of errors. I added the data analysis to my ribbon.
I agree with you that Excel can help decrease errors. I like that the video is easy to follow.
This video was interesting. This is something that I struggle with!
I am still trying to gain a more thorough understanding of this process but this video did help with some of my questions
This video was easy to understand although I have limited experience doing calculations in Excel.
I appreciate and understand the need for the videos, but for me I am a hands on learner. I get what is being explained...but I won't really get it until I actually have to do it. It was very helpful to get a second explanation other than the textbook.
Seeing it done can be helpful
I actually understood this video much more than the previous ones. Excel can do a lot of calculations and formula if you know how to input the data and make your spreadsheet first. It is still easy to make mistakes and there is always to learn more. I am finding I understand more by continued practice. This was easy to follow and excel will do the work for you. It's trying to get it straight inside my head that is confusing.
I think the video was helpful and interesting. I'm not an expert in Excel so it helped learn how to maneuver around while calculating.
So, I was happy with this video because it did not go over my head, at all! I felt like I understood what Dr. Grande was describing and I feel confident that I could replicate it after watching a few more times. It seems if you make a mistake you could easily see where you made the mistake, to go back and fix.
Danielle Maldonado I was happy with this video as well, as it was easier to understand. It is always a good feeling when you feel confident on something you just learned about. I am glad we can refer to these videos because I hadn't known how to do this before.
+Danielle Maldonado i agree. Dr. Grande did a good job with this video. I easily grasped the concepts.
Bless you, Dr. Todd.
Although this seems like simple that would be so simple, there are many steps involved and because this is something that I believe get used a lot in research, it probably necessary to understand and have something to reference.
Although I can replicate this, I think I'll need some more practice (and reminders) when/if using this in a real world scenario. I think Excel (and Dr.G) makes these functions look so easy. Actually practicing and using Excel is a different story. I appreciate having these videos handy so we are able to reference when needed! Thank you!
I feel like eventually, Dr. G. is going to have to include some sort of excel 101 in his research course.
Yea I agree with you Andrew. When I stats in undergrad we learned how to do everything on pen and paper, which is practically useless without learning the software.
I too believe this video is a great tool. Once you know what excel functions to use the conversion of data is just a click away.
Amanda Yarn I agree with you Amanda that I would need a reminder since I don't use this information very often. It is nice to know that these videos are publically available for future access.
so useful! Thanks for sharing.
This video was very easy to follow along with and easy to understand. I thought that the index function was pretty cool.
Susan Wilder I agree that this video was easy to follow. I liked the index function because it allowed the percentile ranges to be calculated all the way through the data set.
Susan Wilder This was one of the easier videos to follow. I feel more confident about percentile ranks because of this. I was a lot of information though so I think I'd have to save this video for future refrence.
Very helpful. Thank you.
Thanks.understood everything.
Please zoom out window for better view on a smartphone
This video makes calculating percentile ranks very clear! I appreciate the step by step explanation as I have previously mentioned, I am not familiar with excel. Although the steps were clearly explained in this video, I am still a tad confused on how to utilize the formula in excel.
Eva, I too thought it was clear, enjoyed this video! I too really appreciate the step-by-step explanations.