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.
@MyDonh
8 жыл бұрын
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.
@8shelbyg
9 жыл бұрын
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.
@marissabarnes4084
5 жыл бұрын
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.
@kristinblake9294
5 жыл бұрын
I agree that a clean spreadsheet is very important so that things don't get jumbled and hard to understand.
@rachelfoster5463
9 жыл бұрын
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.
@aliciazahn1718
9 жыл бұрын
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.
@daniellemaldonado631
9 жыл бұрын
Rachel Foster Yes, this video was easy to follow compared to some previous videos. This video made it seem user friendly.
@juliecampana2860
9 жыл бұрын
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.
@joe1579
6 жыл бұрын
This video is helpful, and easy to follow for people who are not too familiar with using Excel in this way.
@kassietrala378
5 жыл бұрын
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.
@michellerobinson968
9 жыл бұрын
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.
@RyanPclifton
5 жыл бұрын
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.
@alexisklair3164
9 жыл бұрын
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!
@sammiejo6344
9 жыл бұрын
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.
@amandavalentino8182
5 жыл бұрын
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.
@katherinebeck593
9 жыл бұрын
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.
@jillbeck6917
6 жыл бұрын
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.
@wardellwhittaker859
6 жыл бұрын
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.
@meganblackwell8600
9 жыл бұрын
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!
@jackiedeleonardis1153
5 жыл бұрын
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.
@ashleymogle2700
5 жыл бұрын
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!
@tamarabakergibbons5715
5 жыл бұрын
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.
@wardellwhittaker859
6 жыл бұрын
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.
@rachelnewberry1089
5 жыл бұрын
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!
@jacklinskibicki6098
9 жыл бұрын
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.
@jazzynovy5400
9 жыл бұрын
Jacklin Skibicki I agree. very helpful if we have to calculate percentiles rather than static numbers to present findings
@kimberlydixon8760
9 жыл бұрын
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.
@brittanyvodzak9198
9 жыл бұрын
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.
@rachelfoster5463
9 жыл бұрын
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.
@virginiamurrey9139
6 жыл бұрын
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.
@melissahansbury6522
8 жыл бұрын
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.
@angelinastanton7996
6 жыл бұрын
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.
@virginiamurrey9139
6 жыл бұрын
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.
@cassiemclaughlin9489
8 жыл бұрын
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.
@ammu9810
9 жыл бұрын
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.
@8shelbyg
9 жыл бұрын
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.
@sherrietilghman2745
9 жыл бұрын
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.
@dawnb.9315
9 жыл бұрын
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.
@sarahjones208
7 жыл бұрын
I am not a skilled excel user so this was extremely helpful in helping explain things in an easy to understand form.
@deniseswindell2175
5 жыл бұрын
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
@E2M5I0L4Y
9 жыл бұрын
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!
@MichaelSmith-jd5ki
9 жыл бұрын
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.
@johnchristinadarwin8477
5 жыл бұрын
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.
7 жыл бұрын
great job - clear, gentle, everybody could understand! Thank you very much. We "nonexperts" need more tutorials like this.
@DrGrande
7 жыл бұрын
I'm glad you found this video useful. Thanks for watching.
@remygooch1393
5 жыл бұрын
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.
@laurynmoffa
5 жыл бұрын
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.
@aud15chou80
9 жыл бұрын
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.
@cherylchance904
7 жыл бұрын
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.
@remigiusdemby7433
7 жыл бұрын
That correct Cheryl.
@scottmartin7764
8 жыл бұрын
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.
@JamieB
5 жыл бұрын
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.
@jhoward1129
9 жыл бұрын
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.
@ericahammond9901
5 жыл бұрын
This video was informative! Dr. Grande described how to use percentile rank in simple easy to follow steps.
@caitlinfields3175
9 жыл бұрын
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.
@JoeDirt-el2fr
6 жыл бұрын
These videos help me understand how to better use excel. I am somewhat familiar with spss, however this is broadening my horizon.
@wandamixon5360
6 жыл бұрын
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.
@jazzynovy5400
9 жыл бұрын
Very useful to figuring out percentile rank and step by step instructions how to do the calculations in Excel.
@simonehenry469
9 жыл бұрын
Jasmine Aviles yes i agree
@imonutube1
9 жыл бұрын
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.
@ashleydorsey6745
9 жыл бұрын
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.
@jacklinskibicki6098
9 жыл бұрын
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.
@MichaelSmith-jd5ki
9 жыл бұрын
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?
@CandyKaneLane
9 жыл бұрын
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.
@toniettemorda6247
9 жыл бұрын
Candace Fernandez Agreed! The easy step by step excel instructions made this alot easier!
@mandabear52289
9 жыл бұрын
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.
@kimberlydixon8760
9 жыл бұрын
Mandy Moore I completely agree that this video was probably one of the easiest to follow so far.
@kimberlykelly386
9 жыл бұрын
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!)
@sherrietilghman2745
9 жыл бұрын
I like when I have step by step instructions. I can follow that easier and am more likely to understand the function.
@aliciazahn1718
9 жыл бұрын
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.
@danielamoore1412
9 жыл бұрын
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!
@angeliquecastro2209
9 жыл бұрын
I agree that its nice to know that these functions are available! I think the difficulty with that is locating them within the program!
@jessicamcnemar182
9 жыл бұрын
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! :)
@robertrobertsjr.2245
9 жыл бұрын
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.
@genevabarnes7402
9 жыл бұрын
I agree Daniela that the videos are helpful. At times it can get confusing, but I keep trying to understand it.
@danielamoore1412
9 жыл бұрын
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...
@danielleduboski151
7 жыл бұрын
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.
@angelagrimes3994
7 жыл бұрын
Seeing it done can be helpful
@teachereducationsimplified
4 жыл бұрын
Thanks.understood everything. Please zoom out window for better view on a smartphone
@diane3460
7 жыл бұрын
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.
@andrewr6433
9 жыл бұрын
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.
@suzgen7323
6 жыл бұрын
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.
@nickberenato3131
9 жыл бұрын
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.
@brittanyrio3619
9 жыл бұрын
Eva, I too thought it was clear, enjoyed this video! I too really appreciate the step-by-step explanations.
@daniellemaldonado631
9 жыл бұрын
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.
@rebeccameece013
9 жыл бұрын
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.
@Mjthfdj
9 жыл бұрын
+Danielle Maldonado i agree. Dr. Grande did a good job with this video. I easily grasped the concepts.
@rebeccameece013
9 жыл бұрын
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.
@toniettemorda6247
9 жыл бұрын
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.
@thecorgisquad9861
9 жыл бұрын
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.
@CandyKaneLane
9 жыл бұрын
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.
@E2M5I0L4Y
9 жыл бұрын
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.
@ushalincoln9224
6 жыл бұрын
This was a very easy to follow video and is a great resource to know how to use Excel to calculate percentile rank.
@alexdeloach6472
6 жыл бұрын
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.
@briannagoitiandia9833
6 жыл бұрын
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.
@joseliz8762
5 жыл бұрын
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.
@melissaclendaniel9811
9 жыл бұрын
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.
@thecorgisquad9861
9 жыл бұрын
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.
@jhoward1129
9 жыл бұрын
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.
@rhondabaileyyy
6 жыл бұрын
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.
@chelseydavis4989
9 жыл бұрын
I am still trying to gain a more thorough understanding of this process but this video did help with some of my questions
@ariadnaaguero-roman5525
9 жыл бұрын
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.
@angiemorales8481
9 жыл бұрын
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.
@caitlinfields3175
9 жыл бұрын
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 :)
@dawnb.9315
9 жыл бұрын
I agree Angie. I think this will be helpful in the future and hope to access this video in the future.
@mandabear52289
9 жыл бұрын
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,
@imonutube1
9 жыл бұрын
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
@bethanyelstrom3566
9 жыл бұрын
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.
@cherylchance904
7 жыл бұрын
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.
@karaannsullivan2363
7 жыл бұрын
Cheryl, I agree with you and Mandy! Breaking the data down into "digestible" parts is extremely helpful for researcher and reader.
@remigiusdemby7433
7 жыл бұрын
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.
@ninastreet4630
7 жыл бұрын
Remy, I agree. Dr. Grande makes it easy to understand when he creates the videos. I like the step by step process he takes
@susanwilder7616
9 жыл бұрын
This video was very easy to follow along with and easy to understand. I thought that the index function was pretty cool.
@melissaclendaniel9811
9 жыл бұрын
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.
@reneemendez4287
9 жыл бұрын
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.
@zureezee1887
7 жыл бұрын
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.
@briannagoitiandia9833
7 жыл бұрын
Like many of the other videos, seeing how to run the analysis on excel is helpful in understanding the purpose of the analysis
@vidaadansi5633
9 жыл бұрын
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.
@chun10041
3 жыл бұрын
Hi! Just wanna thank you for your video. Now I know how to use the percentile
@brittanyrio3619
9 жыл бұрын
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.
@andrewr6433
9 жыл бұрын
pen and paper? what's that?
@vidaadansi5633
9 жыл бұрын
I agree Britt. We have to get used to excel and practice more.
@angiemorales8481
9 жыл бұрын
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.
@amandayarn5160
9 жыл бұрын
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!
@andrewr6433
9 жыл бұрын
I feel like eventually, Dr. G. is going to have to include some sort of excel 101 in his research course.
@andrewlightfoot1560
9 жыл бұрын
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.
@aud15chou80
9 жыл бұрын
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.
@suzanneedwards1286
9 жыл бұрын
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.
@zureezee1887
6 жыл бұрын
i always find excel calculations difficult to follow and thereby appreciate you showing the calculation step by step
@reneemendez4287
9 жыл бұрын
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.
@genevabarnes7402
9 жыл бұрын
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.
@rachelfoster5463
8 жыл бұрын
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.
@jpincinjr
8 жыл бұрын
I agree with my previous comment as well
@emilytwomey7817
7 жыл бұрын
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.
@etenbroeck
Жыл бұрын
Thank you for your many contributions Dr. Grande! This was very helpful indeed. E
@Mjthfdj
9 жыл бұрын
Easy to follow. Easy to understand. Very helpful.
@jessicamcnemar182
9 жыл бұрын
Great tutorial on excel here. I will probably watch this a few more times. I want to know how to freeze that top row with the titles in it, that made it so much easier to read when scrolling down to the scores towards the bottom.
@kendallwilson7319
9 жыл бұрын
I agree, this was a really great tutorial and I think I will use it in the future. To freeze the top row, (depending on the version of excel you have because I know sometimes they change the smallest things) in excel 2013, you can go to view and then there is a freeze pane option in the ribbon where you can freeze the top row or the first column. I know that definitely comes in handy from my own experience so I hope that helps :)
@angeliquecastro2209
9 жыл бұрын
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.
@danielamoore1412
9 жыл бұрын
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!
@nickberenato3131
9 жыл бұрын
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!
@juliecampana2860
9 жыл бұрын
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.
@suzanneedwards1286
9 жыл бұрын
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.
@brittanyhoffman8068
5 жыл бұрын
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.
@monicaperry13
6 жыл бұрын
This video was easy to understand although I have limited experience doing calculations in Excel.
@kendallwilson7319
9 жыл бұрын
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.
@amandayarn5160
9 жыл бұрын
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!
@alexisklair3164
9 жыл бұрын
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.
@carolkirby5869
7 жыл бұрын
excellent refresher - watched this for Research. I love the expandability of Excel.
@rosasutton8472
7 жыл бұрын
I also remember watching this for Research, so it was nice to have a refresher.
@tammywitzke6642
7 жыл бұрын
its always helpful to be refreshed on the use of Excel
@carolkirby9558
8 жыл бұрын
Intel is very intuitive. It is amazing how much more efficient we work with spreadsheet without having to do that manual calculations and risk errors. This video was very helpful and I too added Data Analysis to my Ribbon.
@kimberlykelly386
9 жыл бұрын
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).
@scottmartin7764
7 жыл бұрын
Great video and very informative, it's nice to see it done and not read from the book.
@michellerobinson968
8 жыл бұрын
This was a nice refresher. It was easy to follow and informative when being applied in this manner.
@ShoreMeetsFarm
5 жыл бұрын
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.
@felia_0027
Жыл бұрын
thankyou for this video, it really helps me lot to do my essay
Пікірлер: 211