Frequency Function in Excel

[@paristexas72]

Wow. I was pleasantly surprised that you are multi-talented. I thought there must be two Dr. Grande teaching KZbinrs. I enjoy both of your talents!

[@brunnogorgulhosoares4441]

Finally somebody who actually explains how to use this function! Even the help guide in Excel doesn't.

[@DrGrande]

I'm glad you found the video useful.

[@alainavangelder5327]

Dr. Grande has created a fantastic resource with these videos that can be accessed at any point in the future. I think seeing this laid out in Excel was very helpful.

[@simonehenry469]

Alaina Van Gelder yes he has. great video.

[@amandavalentino8182]

Dr. Grande- Thank you for showing the breakdown on finding the frequency. You always give an exceptional understanding on how to use Excel and how to ensure the calculation is right. It is always easy to watch your videos.

[@sean9462]

Just want to say thank you. I am taking a stats class and this video really helped me out.

[@rachelfoster5463]

There are so many functions to use in Excel, and I am extremely grateful that these videos will be on KZbin for me to access at any time. I really liked seeing the frequency in a histogram because I am more of a visual person. Therefore, I will utilize histograms and graphs as much as possible.

[@alainavangelder5327]

Rachel Foster I couldn't agree more! There is no way I would remember all of these functionalities of Excel so these videos will be priceless going forward.

[@ariadnaaguero-roman5525]

I agree that there so many functions in excel and these videos help understand and it makes a lot more sense to me when there is a visual.

[@rebeccameece013]

Being more of a visual learner, I was happy that I can view this video to see how the histograms frequency works. The description of the term "bins" helped me as well, because I was a bit confused at first as to what that meant. Dr. Grande always is clear on that he states in his videos, which is helpful.

[@Mjthfdj]

This was the first time I have ever heard of bins but Dr. Grande did a good job explaining it. This video was informative and proved once again the many uses of Excel.

[@E2M5I0L4Y]

Seeing lots of numbers in a data set can be overwhelming. I liked that this video showed how to consolidate the data into bins and then (for those of us who are visual learners), in a histogram. Hearing and listening to this video made the concept of bins more understandable.

[@marisamaguire8136]

Having little knowledge of operating excel, I really enjoyed this visual step-by-step walkthrough of how to properly utilize the frequency function. I found the material to be straightforward and easy to follow. I will definitely be referring back to this video in the future.

[@remygooch1393]

A simple and effective video for a practical application with data. You make using excel a breeze. Thanks Dr. Grande.

[@ShoreMeetsFarm]

This video was very helpful in providing exact directions related to performing the frequency function. This will be most helpful should ever I need to determine the number of individuals falling into different categories or otherwise within my studies moving forward. I’m sure I will be referencing this post again!

[@maywest1016]

This video was extremely informative. Dr. Grande demonstrated how to use the independent variable to find the score, bins, and frequency. The histogram was a nice feature. The histogram helped visualize the data. I could understand the data better by viewing the histogram.

[@bethanyelstrom3566]

***** I found the histogram to be helpful. I am a visual learner and for me it was easier to understand. I find the function of Excel to be user friendly as long as you know what the function shortcut is.

[@katherinebeck593]

In my statistics class I always enjoyed watching the teacher make histograms and different charts. This video was really helpful in showing the detail of the data and how it can be transformed.

[@jazzynovy5400]

This video helped me learn how to transfer raw data and input it into a chart. Not everyone is able to read raw data, especially trying to present it. This was also very helpful to learn what goes on the y-axis versus the x-axis.

[@ericahammond9901]

This video is helpful when finding the frequency. Dr. Grande explained how to find frequency in excel in great detail in multiple ways without being over complex.

[@krystleclear14]

I like the ease of this one. Nice addition to visually see the frequency with a histogram to compare scores.

[@kimberlykelly386]

Another clear, concise video - I liked it! I particularly appreciated the initial explanation that I could take details notes on and then was able to just watch Dr. Grande do it again to show a more detailed analysis (more bins) and less detailed analysis (less bins). It helped solidify my understanding of these functions. Also, the creation of the histogram was really neat and made making graphs to show data less intimidating.

[@aliciazahn1718]

Kimberly Hanna Yes, this video started out very basic and got more detailed. I, too, liked the progression of being able to see more and less bins.

[@toniettemorda6247]

This is great! It was interesting to see how the score is seen in the frequency function. You can either use columns or display the results on a histogram. That was great...so much easier to view when it is in a chart.

[@CandyKaneLane]

Toniette Morda The chart is definitely much easier to view since it is not clouded with numbers and trying to comprehend what each row and column are expressing.

[@thecorgisquad9861]

Toniette Morda I liked seeing the two different ways to display the results. If you have difficulty interpreting what they look like using columns, then you can try and understand it better in a histogram. Great!

[@remigiusdemby7433]

Thanks Dr. Grande for the wonderful job you're doing with these videos. They really facilitate my learning process.

[@thecorgisquad9861]

It is always nice to be able to conceptualize a function via visual representations like histograms, charts, and graphs. I have never found the frequency function to be difficult to carry out, but most things always make much more sense when you can see what the results physically look like.

[@toniettemorda6247]

Jessica Muzzin Yes, agreed! I am visual learner so for me this was great! Its alot easier to view data in a graph or chart to see how one's results are displayed.

[@kimberlydixon8760]

Toniette Morda I thought the histogram was really nice because I also am better able to understand when I have a visual.

[@rebeccameece013]

Jessica Muzzin I agree that it is really nice to be able to better understand a function of something through a visual representation. It always does make more sense when you can view it and see what the results look like, as you stated. These videos are a good reference if we are ever confused about something.

[@jackiedeleonardis1153]

I found this video very helpful for determining the frequency of scores. I like how you can change the information in the bin column to change how basic or complex you want the frequency to be.

[@tammywitzke6642]

I'm a visual learner so adding the histogram was very helpful for me in getting clearer understanding of the data.

[@ariadnaaguero-roman5525]

This video was easy to follow. I work with children and their parents in an evidence-based program and sometimes I use histograms on Excel to analyze data we collect.

[@MichaelSmith-jd5ki]

Great video. Figuring out frequency can be really time consuming, but once again Excel can do it for us.

[@adoniswalk]

This lesson would be good to examine how well one is listening. My fifth try, and I figured out what I was doing wrong. Thank you Dr. Todd Grande. I enjoy your videos.

[@DrGrande]

You're welcome!

[@jacklinskibicki6098]

This video was easy to follow and provided great instruction on analyzing frequency data. I found the bins that categorize the values to be helpful, but thought that the more detailed break down was beneficial in determining how often the values appear, even if not at all. Furthermore, inserting the histogram to display the frequency distribution was helpful in better understanding this function.

[@kimberlykelly386]

Jacklin Skibicki Jacklin, I agree - it was helpful to see a more detailed and less detailed analysis of the same data. It left me feeling more comfortable with this function.

[@kimberlydixon8760]

I thought this video was really informative and easy to follow, I wasn't too familiar with frequency in excel and this video really helped me understand to be more effective in excel.

[@СергейВолчков-г6т]

Thanks to Dr.Grande for clear and simple explanation of a complicated thing. I could not find that in a number of books and help, etc.

[@jhoward1129]

The concept of frequency makes sense to me. It also makes sense that you could show that in graph form, as well as table form. I am continually surprised by how much Excel can actually do. It can probably do things I've been trying to do by hand or by some confusing method, when actually, there is probably some sort of function to do it. This is a neat video and is a good step-by-step tutorial on how to do this.

[@RyanPclifton]

this video showing how to use the frequency function was an informative lesson for me in looking at data differently. prior to this video, i can not recall seeing or using the frequency function in the way that you showed.

[@Boerikoe]

Excellent & precise video. Thank you very much for sharing ! Also a very nice modulated voice to go with it... !

[@ashleymogle2700]

I feel like there are some statistical measures that are more important for counselors to know than others (although in a perfect world we would understand them all as well as Dr. Grande does) but I feel like this is one of them. Not only is it important to understand what each score indicates, but it is also helpful to know how often each score occurs in a patient population. For example, what if you were looking at the frequency of different scores on a suicide/depression inventory given after an experimental treatment.

[@brittanyvodzak9198]

I found the explanation of the bins to be very helpful. This video presented a lot of information but I think that it was very clear and easy to follow.

[@daniellemaldonado631]

At first, I was not sure what "Bins" were, until Dr. Grande explained. As with the previous video, this video was straight forward and I felt like I could replicate it. I can see how this would be useful to condense data.

[@susanwilder7616]

Danielle Maldonado I was confused about what bins were at first as well. It kinda reminded me of shopping ( this is a judge free zone!) and how clearance items are in various bins. haha.

[@Mjthfdj]

+Susan Wilder Good one! Great way to remember bins.

[@brittanyhoffman8068]

Thank you for the video Dr. Grande. I never heard of bins before this video, so that was an interesting concept to learn. I like that we can convert the information into a histogram for a better visual of the information.

[@chelseareeve36]

I did not either! It was also interesting to me that Dr. Grande included discussion of the possibilities of changing the bins numbers to allow for more or less precision.

[@aliciazahn1718]

This was a really insightful video. I vaguely remember bins so it was great to get a refresher and they're surprisingly simple as they are just a set of number that include the scores in a data set. The most helpful part of this, surprisingly, the the piece on making the frequency graph. I make, every now and again, graphs at work and usually start in Word and take my data from one place and type in into the excel box that comes up but this would be so much easier. I can have all the data in an excel spreadsheet and highlight it to put it into the graph. It's so hard to remember everything excel can do, especially when you don't use it frequently so I just keep learning from these videos.

[@michellerobinson968]

Alicia Zahn It is difficult to remember all the functions in Excel however being able to change the Bins and ranges seem so easy.

[@meganblackwell8600]

I was initially lost in this video, but was quickly brought up to speed. This is another feature I was unaware that excel had, and being a visual learner, I liked being able to view this data in a histogram.

[@reneemendez4287]

Megan Blackwell Dr. Grande has shown us how useful Excel can be outside of simple graphing, and how to use these features. I enjoy these videos as well because I can see how to use these features in real time.

[@bethanyelstrom3566]

I found this frequency function video helpful. With any research you will want to know the frequency of the output. The ability to turn the information into a histogram frequency chart helps make the information more visual.

[@rachelfoster5463]

Bethany Elstrom I really appreciated the visual that the histogram provided in this video. I am not very "math oriented." Therefore, a chart full of numbers does not tell me a lot of information. However, a histogram, I can understand much better.

[@daniellemaldonado631]

Bethany Elstrom Yes, I liked that fact that you could turn your input into a histogram in order to get a visual.

[@rhondabaileyyy]

I attempted to follow along in excel myself. I had to watch the video a couple of times, but eventually felt a little more comfortable following the steps.

[@chelseydavis4989]

I like the incorporation of charts into this process. As more of a visual processor I find those additional methods very helpful.

[@remigiusdemby7433]

Chelsey, I share your views.

[@mandabear52289]

I found this video to be very informative. I thought that Dr. Grande offered a clear explanation of the bins and how to read them. I also liked the examples with more or less bins to see the difference between more precision and less precision. It was also very clear on how to go from the data to a histogram.

[@jacklinskibicki6098]

Mandy Moore I agree, this video was much clearer and easier to follow than some of the others. Very useful. And in my opinion, inserting the histogram helped to make the data more easily readable.

[@MichaelSmith-jd5ki]

Mandy Moore I like being able to alter the values in the bins column. An over-all view can be seen with less bins but a more detailed view can be seen with more bins.

[@simonehenry469]

i enjoyed watching this video. it was transforming data at its finest

[@CandyKaneLane]

I remember doing something similar to this in my business class, I like the idea of charts and histograms because it really gives you a better picture of what the data looks like and allows you to see differences as well.

[@mandabear52289]

Candace Fernandez I love graphs. I'm a fairly visual learner so I love being able to see the data in a graph form. It really helps me to see what the data is telling me. Therefore, I found this video very helpful in that I know this is something I will be using in the future.

[@maywest1016]

Candace Fernandez I agree. I like the use of charts. It helps to visualize the data. Also you can view the comparison between numbers more easily.

[@brittanyvodzak9198]

Candace Fernandez I also like the idea of charts because, like Mandy said, I am a visual learner.

[@sherrietilghman2745]

I agree. I like to clearly see what I'm looking at. I think this is important for the reader and the researcher.

[@jazzynovy5400]

Candace Fernandez I agree. I am also a visual learner and learning how to put the data in charts is very helpful

[@michellerobinson968]

I liked how you can add the Bins on the X axis of the graphic chart. This makes it easier to understand the frequency.

[@Pixieburglar]

This video was informative for me. I had never known that you could calculate the frequency of a data set in this manner. As I was watching, I was wondering why you would use a frequency that had intervals instead of individually, however, then I saw that some numbers did not have any occurrences. However, I am glad that the individual set was shown because then you could tell where the numbers actually were placed. I also liked watching the formation of the histogram and how to input the data set. That will be helpful to me in the future instead of manually inserting each number into the graph, I now know how to put an entire set in.

[@meganblackwell8600]

Melissa Clendaniel Inputting the data for a histogram was the most useful piece to me. It really clarified frequency in my mind!

[@PAVANKUMAR-vx9ty]

i am getting result as cummulative values in each rows, and ctrl+shift+enter is not displaying all values at a time. when i press ctrl shift enter only one cell resulting me.

[@pufarinu]

I have to use " ; " instead of " , " in the frequency formula in order to work. Great video!

[@tamarabakergibbons5715]

Although the information was the same, I preferred to see the bins and frequency in the histogram. Thank you for the video Dr. Grande.

[@sitarijal3387]

Hey Dr. Grande could you please help me to make a bar graph, frequency in the y-axis and percentage labeled on the top of the bar?

[@virginiamurrey9139]

I have never used frequency function, this would be very helpful in future research depending on the research project.

[@rhondabaileyyy]

I hadn't used the frequency function before either, but I liked him demonstrating it.

[@laurentori6603]

Can Pivot tables be used instead of frequency?

[@callumjsc7244]

Excellent video! Very helpful and well explained.

[@DrGrande]

Thank you!

[@briannagoitiandia9833]

This video was helpful to be able to have a visual of the data making it easier to interpret

[@JoeDirt-el2fr]

Brianna Goitiandia I agree it's very simple to understand these directions

[@JoeDirt-el2fr]

I like how you can see the frequency of data in this Model. I'm seeing there are so many ways to calculate data

[@raffb4467]

Its like using COUNTIF formula because they return the same values when you use the same set of data and criteria/bins. May I ask if you can use frequency formula to an alphanumeric set of data? Thanks.

[@jwest9155]

What are "bins" though and why do they go by 2's?

[@susanwilder7616]

This was a pretty interesting video. I could see myself forgegtting to hold control before hitting enter when calculating the frequency.

[@joshisi9317]

This was extremely helpful. thanks

[@sablehernandez5406]

Thank you for your demonstration.

[@DrGrande]

You're welcome - thank you for watching.

[@johnq3543]

Thank you sir, that was very helpful.

[@reneemendez4287]

I understand the usefulness of this function because it lets Excel do all the legwork in sorting the frequency of each value, but I fail to understand why would would not make the bins as detailed as possible. I don't know if it was Dr. Grande simply showing that it was a possibility to show the frequency "up to" a certian value, or it that would be useful somewhere. I would rather know how often each value occurs rather than saying that "a value of up to 84 happened X many times".

[@sherrietilghman2745]

This function can analyze a series of values and summarize them into a number of specified ranges.

[@ilyassebendahmane1247]

Thank you so much ❤️❤️

[@tirthankarchakraborty3461]

thank u so much..

[@louf7178]

FYI: I'm going to guess "BINS" refers to binary numbers.