Excel Frequency Function

This video shows how to use excel's frequency function.

[@ptseti]

I cannot tell you how you made this SO EASY and you are a great instructor. Thank U

[@crowsmathclass]

Thank you.

[@khalidrehman5045]

Hi Steve, thanks for sharing, i have watched many videos on frequency but this was the perfect one. Thumbs up

[@crowsmathclass]

Thank you. Glad it helped.

[@eduardo0796]

As a complete Excel newbie, this video really helped a lot.

[@crowsmathclass]

Thank you for the comment. Glad it helped.

[@janicelayne9053]

Very thorough with a steady and easy to understand delivery-thank you!

[@crowsmathclass]

Thank you.

[@matthewmillard9775]

Hi. I am stumped. I used the the formula =frequency( when I select the rows and columns of numbers that are imputed. And then I imputed the range Of cells 1 thru 25 that I would want excel to identify the frequency of the number of times that a particular number came up. Once I had to formula completed, I ran into the problem of if I asked it how many times the number one came up, it would count the "1"s including the ones in double digit form, such as 10-19, 21.. It does this on other numbers as well, such as 2s and 3" Is there a fix so it only identifies and counts the singular "1"s when identifying the numbers between 1 and 25? Or am I just using the wrong formula?

[@atashingmi4030]

the explanation is so clear, thank you so much!!

[@crowsmathclass]

You’re welcome.

[@harrisonbrierley254]

This was brilliant. Thank you.

[@crowsmathclass]

Thank you. Glad it helped.

[@ambikayadav495]

It's very helpful man, thank you sooooo much! And special thanks for telling about ' holding control+ shift and then enter', otherwise I would have to either scroll after every column or enter the function EVERYTIME. Thanks a lot! Keep making such amazing informative videos and your pace of teaching was also perfect 🙌👌

[@crowsmathclass]

Thank you for the comment. Glad it helped.

[@odiles417]

Thank you, this worked, and you explain it better than my textbook lol

[@crowsmathclass]

You’re welcome. Glad it helped.

[@gavintomlinson777]

Thank you. You made this clear and simple.

[@crowsmathclass]

Thank you. Glad it helped.

[@MR95.1]

It was very helpful to me... It was my assignment ...i was just collapsed.. But after seeing this video I was clear.. Thank you very much for sharing

[@crowsmathclass]

You’re welcome. Glad it helped.

[@MR95.1]

@@crowsmathclass yes it was very useful.....

[@devereux20]

Buddy, you literally dug me out of a hole! Thanks man 👍🏻

[@crowsmathclass]

You’re welcome. Glad it helped.

[@devereux20]

@@crowsmathclass 😄🙏🏻

[@Anca07M]

Hello, great video. Do you know why this doesn't work when the data_array is all included in one column instead of several columns and rows? Thank you!

[@crowsmathclass]

It works for one column.

[@allendegrano8764]

Hi can you do a tutorial about making frequency table only colors?

[@maykathlynrebustillo4985]

This is very helpful. Thank you for sharing it.

[@crowsmathclass]

You’re welcome. Glad it helped.

[@jihuiwang3994]

thank you so so so so so so much! you help me a lot !!!

[@crowsmathclass]

You’re welcome. Glad it helped.

[@carolpatonx]

Brilliant video. Made this so easy to understand helped me with my assignment. Thank you!!

[@crowsmathclass]

Thank you. Glad it helped.

[@6KArkade]

thank you much, really appreciate this, save me from doing a lot of manual work...

[@crowsmathclass]

You’re welcome. Glad it helped.

[@yehah]

Thank you for the video. It helped me a lot.

[@crowsmathclass]

You’re welcome. Glad it helped.

[@madelinefranz7890]

Best explanation available thank you

[@crowsmathclass]

Thank you. Glad it helped.

[@prakritipriya3680]

Thank you so much. 😊 finally I got the answer 🥳

[@crowsmathclass]

You are welcome 😊

[@antonioacevedo1762]

My man ! Appreciate it boss.

[@crowsmathclass]

You’re welcome.

[@diegoperezlopez6059]

this was great, you so so much!

[@diegoperezlopez6059]

thank you*

[@shanniahcooper2890]

Thank you for this video it helped alot

[@crowsmathclass]

You’re welcome.

[@benjaminshen2079]

Can you advise when you select the bin array, why would you exclude A11?

[@crowsmathclass]

You don’t include the highest interval.

[@benjaminshen2079]

@@crowsmathclass Thank you Steve

[@gmrx4452]

Finally, thanks for helping us

[@crowsmathclass]

You’re welcome.

[@stevenwilson5556]

Thank you Steve Crow!

[@crowsmathclass]

You’re welcome.

[@kalyanigorti342]

It was too good. Wonderful & simple explanantion

[@crowsmathclass]

Thank you.

[@ejtischler1480]

Hey Buddy great video lots of help

[@crowsmathclass]

Thank you.

[@user-hg5qk4dd8d]

At the 2:30 mark you said you have to choose "one more cell than you have the bins array" But when you did the formula, you did not do that. So what is the right way? The way you said or the way you shown?

[@professional_pickme_boy]

He selected 4 cells And there are 3 cells for the bin array

[@vigneshkr9497]

How to sort this matrix in ascending order?

[@Blazeinbluebecausewhynot]

Unrelated topic but ur voice is really soothing 😌

[@crowsmathclass]

Thank you.

[@abowlofawesome5517]

Very good tutorial, but I have one problem. Its like I can't use frequency. If I do what you do, it has an error. Than I thought about it and I came to the conclusion that that function does not exist in my excel if you get what I mean. Doe I have to activate it somewhere or put it back on or is it maybe because of my add-ons?

[@crowsmathclass]

That is strange. Frequency function should be in your excel.

[@birdwatcher899]

Thank you so much!

[@crowsmathclass]

You’re welcome.

[@Aadu0803]

Extremely helpful.

[@crowsmathclass]

Thank you. Glad it helped.

[@hayderal-sarraf667]

Great! Thank you

[@crowsmathclass]

You’re welcome.

[@noname-gg8ns]

THANK YOU!!!

[@crowsmathclass]

You’re welcome.

[@mehmetdogu384]

you are number 1 for me.

[@crowsmathclass]

Thank you.

[@sulleymanissaka6729]

Can the data aray be just one column of Numbers?

[@crowsmathclass]

Yes.

[@sulleymanissaka6729]

Thanks, I tried it worked

[@jijiahji]

you saved me from having to tally up 80 things 😭😭 thank you

[@crowsmathclass]

You’re welcome. Glad I could help.

[@barbarabah2870]

wiiii, i made it. Hvala!

[@crowsmathclass]

👍

[@xrtt3562]

U are hero man

[@crowsmathclass]

Thank you. Glad it helped.

[@Aman_Yadavvvvv]

Thank you so much

[@crowsmathclass]

You’re welcome.

[@lostchee-lj7ie]

thanks!!

[@crowsmathclass]

You’re welcome.

[@user-pg1zm9no3f]

Thanks for helping

[@crowsmathclass]

You’re welcome.

[@notscot6788]

Well done. Nice explanation.

[@crowsmathclass]

Thank you.

[@manghudart1329]

I wasted my 1 hour because of that 'holding control+ shift and then enter'. (T_T) Thanks Sir for showing the difference. Stay safe!

[@crowsmathclass]

You’re welcome. Glad it helped.

[@O.rdinary_boy]

Thank you... 😌😌😌for solving my problem

[@O.rdinary_boy]

How I can fix these random numbers???

[@crowsmathclass]

You’re welcome.

[@bebekkartal]

enter or "Inner" ????

[@LauraTeAhoWhite]

Are you sure you aren't Bob Ross?

[@jithin9418]

Thank you

[@crowsmathclass]

You’re welcome.

[@vineethv37]

👌

[@sarahcoleman9480]

I don't get where you pulled your intervals from

[@crowsmathclass]

I just made them up.

[@sarahcoleman9480]

@@crowsmathclass what if I only have one column of numbers and some are decimals

[@crowsmathclass]

You have to have two columns.

[@sarahcoleman9480]

@@crowsmathclass nope I have one

[@crowsmathclass]

The frequency function tells you how many data values are between two numbers. This is why you must have two columns of numbers.

[@carltoncurtis3934]

Ctrl+Shift+Return is the key

[@aureliendv9374]

What about new macs that don't have a return button anymore?

[@reignfilms4139]

how did u get 0 to 9 10 to 19 ITS SO CONFUSING po huhu

[@christianevensantillan2036]

Ikaw yong magdedecide nong interval na gusto mo po