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.

[@atashingmi4030]

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

[@crowsmathclass]

You’re welcome.

[@gavintomlinson777]

Thank you. You made this clear and simple.

[@crowsmathclass]

Thank you. Glad it helped.

[@devereux20]

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

[@crowsmathclass]

You’re welcome. Glad it helped.

[@devereux20]

@@crowsmathclass 😄🙏🏻

[@odiles417]

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

[@crowsmathclass]

You’re welcome. Glad it helped.

[@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.

[@maykathlynrebustillo4985]

This is very helpful. Thank you for sharing it.

[@crowsmathclass]

You’re welcome. 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.....

[@yehah]

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

[@crowsmathclass]

You’re welcome. 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.

[@Aadu0803]

Extremely helpful.

[@crowsmathclass]

Thank you. 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.

[@prakritipriya3680]

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

[@crowsmathclass]

You are welcome 😊

[@jihuiwang3994]

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

[@crowsmathclass]

You’re welcome. Glad it helped.

[@antonioacevedo1762]

My man ! Appreciate it boss.

[@crowsmathclass]

You’re welcome.

[@gmrx4452]

Finally, thanks for helping us

[@crowsmathclass]

You’re welcome.

[@kalyanigorti342]

It was too good. Wonderful & simple explanantion

[@crowsmathclass]

Thank you.

[@stevenwilson5556]

Thank you Steve Crow!

[@crowsmathclass]

You’re welcome.

[@shanniahcooper2890]

Thank you for this video it helped alot

[@crowsmathclass]

You’re welcome.

[@madelinefranz7890]

Best explanation available thank you

[@crowsmathclass]

Thank you. Glad it helped.

[@ejtischler1480]

Hey Buddy great video lots of help

[@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?

[@mehmetdogu384]

you are number 1 for me.

[@crowsmathclass]

Thank you.

[@Blazeinbluebecausewhynot]

Unrelated topic but ur voice is really soothing 😌

[@crowsmathclass]

Thank you.

[@notscot6788]

Well done. Nice explanation.

[@crowsmathclass]

Thank you.

[@diegoperezlopez6059]

this was great, you so so much!

[@diegoperezlopez6059]

thank you*

[@O.rdinary_boy]

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

[@O.rdinary_boy]

How I can fix these random numbers???

[@crowsmathclass]

You’re welcome.

[@jiji629]

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

[@crowsmathclass]

You’re welcome. Glad I could help.

[@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.

[@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.

[@birdwatcher899]

Thank you so much!

[@crowsmathclass]

You’re welcome.

[@allendegrano8764]

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

[@hayderal-sarraf667]

Great! Thank you

[@crowsmathclass]

You’re welcome.

[@noname-gg8ns]

THANK YOU!!!

[@crowsmathclass]

You’re welcome.

[@user-pg1zm9no3f]

Thanks for helping

[@crowsmathclass]

You’re welcome.

[@lostchee-lj7ie]

thanks!!

[@crowsmathclass]

You’re welcome.

[@xrtt3562]

U are hero man

[@crowsmathclass]

Thank you. Glad it helped.

[@Aman_Yadavvvvv]

Thank you so much

[@crowsmathclass]

You’re welcome.

[@barbarabah2870]

wiiii, i made it. Hvala!

[@crowsmathclass]

👍

[@jithin9418]

Thank you

[@crowsmathclass]

You’re welcome.

[@vigneshkr9497]

How to sort this matrix in ascending order?

[@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

[@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.

[@vineethv37]

👌

[@LauraTeAhoWhite]

Are you sure you aren't Bob Ross?

[@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

[@carltoncurtis3934]

Ctrl+Shift+Return is the key

[@aureliendv9374]

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

[@bebekkartal]

enter or "Inner" ????

[@sulleymanissaka6729]

Can the data aray be just one column of Numbers?

[@crowsmathclass]

Yes.

[@sulleymanissaka6729]

Thanks, I tried it worked

[@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.

[@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