Calculating Percentile Rank Using Excel

This video describes how to calculate percentile rank using Microsoft Excel.

[shelbyg]

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.

[chelseareeve]

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.

[wardellwhittaker]

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.

[jillbeck]

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.

[alexisklair]

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!

[MyDonh]

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.

[kassietrala]

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.

[rachelfoster]

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.

[marissabarnes]

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.

[ashleymogle]

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!

[katherinebeck]

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.

[joe]

This video is helpful, and easy to follow for people who are not too familiar with using Excel in this way.

[RyanPclifton]

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.

[jackiedeleonardis]

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.

[amandavalentino]

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.

[melissahansbury]

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.

[juliecampana]

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.

great job - clear, gentle, everybody could understand! Thank you very much. We "nonexperts" need more tutorials like this.

[meganblackwell]

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!

[tamarabakergibbons]

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.