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.
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.
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.
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.
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.
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.
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.
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 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.
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.
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!
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!
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.
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 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 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!
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 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.
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 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.
7 років тому
great job - clear, gentle, everybody could understand! Thank you very much. We "nonexperts" need more tutorials like this.
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.
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.
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!
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.
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.
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 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...
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.
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 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
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 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.
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.
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 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 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.
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 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 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.
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. Being someone who uses excel, this was helpful in viewing as i will use this for academic and professional purposes.
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.
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.
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.
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 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.
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.
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.
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 was very informative. Since I am not that good with excel, this made learning it a lot easier understanding how to calculate percentile data. Its very interesting to see how easy it can be to calculate the participants and how it is ranked.
Toniette Morda I also thought this was an easy video to follow along with. I think Excel is confusing sometimes, so I have found it to be helpful to actually follow along with the video and make my own spreadsheet in Excel. This has helped to solidify the learning for me. SPSS was what I was more familiar with, so I prefer it because it seems to be more user-friendly.
Toniette Morda I also am not very good with excel so having the easy to follow directions made it helpful to better understand how to calculate the percentile ranks. I liked how in the video it showed us how to put the correct points with the correct participants and being able to use autofill in order to avoid having to type every single one.
Toniette Morda I have noticed in the past when I have watched videos with instructions, I get stuck when I have to do it myself because my settings are different than how the instructor's computer is set. I liked that Dr. Grande showed us how to adjust our options to ensure that the correct add-ins are checked.
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.
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.
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.
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.
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.
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.
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 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 enjoyed this video very much because it was easier for me to follow and apply. Also I can see how this information can be directly needed in practice for gathering and organizing client information. This is good for not just research but for usage within agencies for determining different factors among clients.
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 video was very helpful and easy to follow along with the step by step instructions. I too see how this is much easier than calculating with just pen and paper. This stat video was much easier for me to understand. I have to start getting used to using excel and this tool didn't seem out of reach for me which is nice.
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 really appreciated this video because I hate figuring out and trying to understand percentile ranks, so I am now happy that I could do that in excel if I need to in the future. I think I understand percentile ranks but I do not understand it enough to explain it and therefore it just ends up confusing me more.
I totally agree! Excel and Dr. G make these functions look so easy! I think this is a great tool to have. And having the video to reference at any time is great!
I totally agree. presented in a very clear and concise manner. Calculating it this way is much quicker and this is a helpful video that we can always refer back to alongside our actual data if needed. I think with practice it would be even quicker to just do these few steps and quickly calculate percent without headache.
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.
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).
percentile and rank are two statistics or values that I have struggled with in the past in stats classes. This video is one that I will probably revisit again and again. Scores, rank, and percentile are all generated with the formula, so having a data set and calculating these things seems doable. I think it was nice to see how to organize the data set to get the participant id in front of all the new numbers instead of the point.
Me too, Angelique! It's a bit challenging for me to understand percentile. This video was very helpful and I can honestly say I'll be watching it again. When the numbers changed, I got a bit confused. But I paused and went back to make sure I understood what Dr. Grande did. I'm grateful for these videos, tho I will be asking questions in class too, for sure!
I agree, Angelique. Percentile has always been an elusive concept for me. I always feel odd looking at how my students' percentile ranks, because I have no idea how they are calculated. At least now I have a little bit more background knowledge when explaining percentile rank to someone. I also liked how the data was organized and how the video showed how all of this is able to be done in excel.
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.
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.
Excel can be a great help in calculating some of the statistical information that we need to obtain. Much easier than doing it by hand but I think I might need more experience with Excel in order to use some of these techniques.
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.
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.
By watching this videos I'm baffled at how many functions excel has that I had no idea about. I think to understand the functions I will need to watch and practice with the video step by step
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.
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.
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.
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.
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.
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.
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.
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 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.
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.
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!
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!
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.
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 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 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!
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 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.
This video is helpful, and easy to follow for people who are not too familiar with using Excel in this way.
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 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.
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.
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.
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.
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.
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!
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.
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.
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
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...
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.
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 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
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 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.
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.
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.
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 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.
I am not a skilled excel user so this was extremely helpful in helping explain things in an easy to understand form.
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 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.
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.
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 informative! Dr. Grande described how to use percentile rank in simple easy to follow steps.
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.
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.
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. Being someone who uses excel, this was helpful in viewing as i will use this for academic and professional purposes.
These videos help me understand how to better use excel. I am somewhat familiar with spss, however this is broadening my horizon.
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.
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.
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.
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 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.
Very useful to figuring out percentile rank and step by step instructions how to do the calculations in Excel.
Jasmine Aviles
yes i agree
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.
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.
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 was very informative. Since I am not that good with excel, this made learning it a lot easier understanding how to calculate percentile data. Its very interesting to see how easy it can be to calculate the participants and how it is ranked.
Toniette Morda I also thought this was an easy video to follow along with. I think Excel is confusing sometimes, so I have found it to be helpful to actually follow along with the video and make my own spreadsheet in Excel. This has helped to solidify the learning for me. SPSS was what I was more familiar with, so I prefer it because it seems to be more user-friendly.
Toniette Morda I also am not very good with excel so having the easy to follow directions made it helpful to better understand how to calculate the percentile ranks. I liked how in the video it showed us how to put the correct points with the correct participants and being able to use autofill in order to avoid having to type every single one.
Toniette Morda I have noticed in the past when I have watched videos with instructions, I get stuck when I have to do it myself because my settings are different than how the instructor's computer is set. I liked that Dr. Grande showed us how to adjust our options to ensure that the correct add-ins are checked.
This was a very easy to follow video and is a great resource to know how to use Excel to calculate percentile rank.
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.
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.
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
Hi! Just wanna thank you for your video. Now I know how to use the percentile
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.
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.
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.
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.
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.
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.
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
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.
I enjoyed this video very much because it was easier for me to follow and apply. Also I can see how this information can be directly needed in practice for gathering and organizing client information. This is good for not just research but for usage within agencies for determining different factors among clients.
I agree! I definitely think this will be useful to organize client information. I just need to try this a few times on my own first :)
I agree Angie. I think this will be helpful in the future and hope to access this video in the future.
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
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 video was very helpful and easy to follow along with the step by step instructions. I too see how this is much easier than calculating with just pen and paper. This stat video was much easier for me to understand. I have to start getting used to using excel and this tool didn't seem out of reach for me which is nice.
pen and paper? what's that?
I agree Britt. We have to get used to excel and practice more.
I agree this video was easier for me to follow and apply if I needed to. It seems people either love Excel or hate Excel.
I am still trying to gain a more thorough understanding of this process but this video did help with some of my questions
Thank you for your many contributions Dr. Grande! This was very helpful indeed. E
Like many of the other videos, seeing how to run the analysis on excel is helpful in understanding the purpose of the analysis
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.
Thanks.understood everything.
Please zoom out window for better view on a smartphone
I really appreciated this video because I hate figuring out and trying to understand percentile ranks, so I am now happy that I could do that in excel if I need to in the future. I think I understand percentile ranks but I do not understand it enough to explain it and therefore it just ends up confusing me more.
I totally agree! Excel and Dr. G make these functions look so easy! I think this is a great tool to have. And having the video to reference at any time is great!
I totally agree. presented in a very clear and concise manner. Calculating it this way is much quicker and this is a helpful video that we can always refer back to alongside our actual data if needed. I think with practice it would be even quicker to just do these few steps and quickly calculate percent without headache.
i always find excel calculations difficult to follow and thereby appreciate you showing the calculation step by step
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.
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).
percentile and rank are two statistics or values that I have struggled with in the past in stats classes. This video is one that I will probably revisit again and again. Scores, rank, and percentile are all generated with the formula, so having a data set and calculating these things seems doable. I think it was nice to see how to organize the data set to get the participant id in front of all the new numbers instead of the point.
Me too, Angelique! It's a bit challenging for me to understand percentile. This video was very helpful and I can honestly say I'll be watching it again.
When the numbers changed, I got a bit confused. But I paused and went back to make sure I understood what Dr. Grande did. I'm grateful for these videos, tho I will be asking questions in class too, for sure!
Hi Angelique! I too will need to revisit this video again.This particular video is a great tool to utilize now and to keep for future review!
I agree, Angelique. Percentile has always been an elusive concept for me. I always feel odd looking at how my students' percentile ranks, because I have no idea how they are calculated. At least now I have a little bit more background knowledge when explaining percentile rank to someone. I also liked how the data was organized and how the video showed how all of this is able to be done in excel.
This was a nice refresher. It was easy to follow and informative when being applied in this manner.
excellent refresher - watched this for Research. I love the expandability of Excel.
I also remember watching this for Research, so it was nice to have a refresher.
its always helpful to be refreshed on the use of Excel
Easy to follow. Easy to understand. Very helpful.
good refresher and i always appreciate the guided instructions.
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.
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.
Great video and very informative, it's nice to see it done and not read from the book.
Excel can be a great help in calculating some of the statistical information that we need to obtain. Much easier than doing it by hand but I think I might need more experience with Excel in order to use some of these techniques.
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.
This video was easy to understand although I have limited experience doing calculations in Excel.
It was good to see this video again. Good refresher from Research
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.
By watching this videos I'm baffled at how many functions excel has that I had no idea about. I think to understand the functions I will need to watch and practice with the video step by step