This video shows how to use excel's frequency function.
Жүктеу.....
Пікірлер: 114
@ptseti Жыл бұрын
I cannot tell you how you made this SO EASY and you are a great instructor. Thank U
@crowsmathclass
Жыл бұрын
Thank you.
@khalidrehman50453 жыл бұрын
Hi Steve, thanks for sharing, i have watched many videos on frequency but this was the perfect one. Thumbs up
@crowsmathclass
3 жыл бұрын
Thank you. Glad it helped.
@eduardo07963 жыл бұрын
As a complete Excel newbie, this video really helped a lot.
@crowsmathclass
3 жыл бұрын
Thank you for the comment. Glad it helped.
@janicelayne90532 ай бұрын
Very thorough with a steady and easy to understand delivery-thank you!
@crowsmathclass
2 ай бұрын
Thank you.
@atashingmi40303 жыл бұрын
the explanation is so clear, thank you so much!!
@crowsmathclass
3 жыл бұрын
You’re welcome.
@harrisonbrierley2543 жыл бұрын
This was brilliant. Thank you.
@crowsmathclass
3 жыл бұрын
Thank you. Glad it helped.
@ambikayadav4953 жыл бұрын
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
3 жыл бұрын
Thank you for the comment. Glad it helped.
@gavintomlinson7772 жыл бұрын
Thank you. You made this clear and simple.
@crowsmathclass
2 жыл бұрын
Thank you. Glad it helped.
@odiles4173 жыл бұрын
Thank you, this worked, and you explain it better than my textbook lol
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
@carolpatonx3 жыл бұрын
Brilliant video. Made this so easy to understand helped me with my assignment. Thank you!!
@crowsmathclass
3 жыл бұрын
Thank you. Glad it helped.
@devereux202 жыл бұрын
Buddy, you literally dug me out of a hole! Thanks man 👍🏻
@crowsmathclass
2 жыл бұрын
You’re welcome. Glad it helped.
@devereux20
2 жыл бұрын
@@crowsmathclass 😄🙏🏻
@MR95.13 жыл бұрын
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
3 жыл бұрын
You’re welcome. Glad it helped.
@MR95.1
3 жыл бұрын
@@crowsmathclass yes it was very useful.....
@maykathlynrebustillo49853 жыл бұрын
This is very helpful. Thank you for sharing it.
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
@yehah2 жыл бұрын
Thank you for the video. It helped me a lot.
@crowsmathclass
2 жыл бұрын
You’re welcome. Glad it helped.
@6KArkade3 жыл бұрын
thank you much, really appreciate this, save me from doing a lot of manual work...
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
@matthewmillard97752 жыл бұрын
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?
@jihuiwang39943 жыл бұрын
thank you so so so so so so much! you help me a lot !!!
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
@prakritipriya36803 жыл бұрын
Thank you so much. 😊 finally I got the answer 🥳
@crowsmathclass
3 жыл бұрын
You are welcome 😊
@stevenwilson55563 жыл бұрын
Thank you Steve Crow!
@crowsmathclass
3 жыл бұрын
You’re welcome.
@antonioacevedo17622 жыл бұрын
My man ! Appreciate it boss.
@crowsmathclass
2 жыл бұрын
You’re welcome.
@madelinefranz78904 жыл бұрын
Best explanation available thank you
@crowsmathclass
4 жыл бұрын
Thank you. Glad it helped.
@kalyanigorti3423 жыл бұрын
It was too good. Wonderful & simple explanantion
@crowsmathclass
3 жыл бұрын
Thank you.
@gmrx44523 жыл бұрын
Finally, thanks for helping us
@crowsmathclass
3 жыл бұрын
You’re welcome.
@shanniahcooper28903 жыл бұрын
Thank you for this video it helped alot
@crowsmathclass
3 жыл бұрын
You’re welcome.
@ejtischler14803 жыл бұрын
Hey Buddy great video lots of help
@crowsmathclass
3 жыл бұрын
Thank you.
@Aadu0803 Жыл бұрын
Extremely helpful.
@crowsmathclass
Жыл бұрын
Thank you. Glad it helped.
@diegoperezlopez6059 Жыл бұрын
this was great, you so so much!
@diegoperezlopez6059
Жыл бұрын
thank you*
@Blazeinbluebecausewhynot2 жыл бұрын
Unrelated topic but ur voice is really soothing 😌
@crowsmathclass
2 жыл бұрын
Thank you.
@birdwatcher8992 жыл бұрын
Thank you so much!
@crowsmathclass
2 жыл бұрын
You’re welcome.
@O.rdinary_boy2 жыл бұрын
Thank you... 😌😌😌for solving my problem
@O.rdinary_boy
2 жыл бұрын
How I can fix these random numbers???
@crowsmathclass
2 жыл бұрын
You’re welcome.
@notscot6788 Жыл бұрын
Well done. Nice explanation.
@crowsmathclass
Жыл бұрын
Thank you.
@mehmetdogu3842 жыл бұрын
you are number 1 for me.
@crowsmathclass
2 жыл бұрын
Thank you.
@allendegrano87642 жыл бұрын
Hi can you do a tutorial about making frequency table only colors?
@Anca07M2 жыл бұрын
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
2 жыл бұрын
It works for one column.
@hayderal-sarraf667 Жыл бұрын
Great! Thank you
@crowsmathclass
Жыл бұрын
You’re welcome.
@noname-gg8ns Жыл бұрын
THANK YOU!!!
@crowsmathclass
Жыл бұрын
You’re welcome.
@user-pg1zm9no3f3 жыл бұрын
Thanks for helping
@crowsmathclass
3 жыл бұрын
You’re welcome.
@jiji6292 жыл бұрын
you saved me from having to tally up 80 things 😭😭 thank you
@crowsmathclass
2 жыл бұрын
You’re welcome. Glad I could help.
@Aman_Yadavvvvv2 жыл бұрын
Thank you so much
@crowsmathclass
2 жыл бұрын
You’re welcome.
@xrtt35622 жыл бұрын
U are hero man
@crowsmathclass
2 жыл бұрын
Thank you. Glad it helped.
@manghudart13292 жыл бұрын
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
2 жыл бұрын
You’re welcome. Glad it helped.
@lostchee-lj7ie3 жыл бұрын
thanks!!
@crowsmathclass
3 жыл бұрын
You’re welcome.
@barbarabah2870 Жыл бұрын
wiiii, i made it. Hvala!
@crowsmathclass
Жыл бұрын
👍
@benjaminshen20793 жыл бұрын
Can you advise when you select the bin array, why would you exclude A11?
@crowsmathclass
3 жыл бұрын
You don’t include the highest interval.
@benjaminshen2079
3 жыл бұрын
@@crowsmathclass Thank you Steve
@abowlofawesome55172 жыл бұрын
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
2 жыл бұрын
That is strange. Frequency function should be in your excel.
@jithin94183 жыл бұрын
Thank you
@crowsmathclass
3 жыл бұрын
You’re welcome.
@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
4 ай бұрын
He selected 4 cells And there are 3 cells for the bin array
@vigneshkr949711 ай бұрын
How to sort this matrix in ascending order?
@carltoncurtis39343 жыл бұрын
Ctrl+Shift+Return is the key
@aureliendv9374
3 жыл бұрын
What about new macs that don't have a return button anymore?
@sulleymanissaka67293 жыл бұрын
Can the data aray be just one column of Numbers?
@crowsmathclass
3 жыл бұрын
Yes.
@sulleymanissaka6729
3 жыл бұрын
Thanks, I tried it worked
@bebekkartal2 жыл бұрын
enter or "Inner" ????
@LauraTeAhoWhite3 жыл бұрын
Are you sure you aren't Bob Ross?
@vineethv3711 ай бұрын
👌
@reignfilms41393 жыл бұрын
how did u get 0 to 9 10 to 19 ITS SO CONFUSING po huhu
@christianevensantillan2036
3 жыл бұрын
Ikaw yong magdedecide nong interval na gusto mo po
@sarahcoleman94802 жыл бұрын
I don't get where you pulled your intervals from
@crowsmathclass
2 жыл бұрын
I just made them up.
@sarahcoleman9480
2 жыл бұрын
@@crowsmathclass what if I only have one column of numbers and some are decimals
@crowsmathclass
2 жыл бұрын
You have to have two columns.
@sarahcoleman9480
2 жыл бұрын
@@crowsmathclass nope I have one
@crowsmathclass
2 жыл бұрын
The frequency function tells you how many data values are between two numbers. This is why you must have two columns of numbers.
Пікірлер: 114
I cannot tell you how you made this SO EASY and you are a great instructor. Thank U
@crowsmathclass
Жыл бұрын
Thank you.
Hi Steve, thanks for sharing, i have watched many videos on frequency but this was the perfect one. Thumbs up
@crowsmathclass
3 жыл бұрын
Thank you. Glad it helped.
As a complete Excel newbie, this video really helped a lot.
@crowsmathclass
3 жыл бұрын
Thank you for the comment. Glad it helped.
Very thorough with a steady and easy to understand delivery-thank you!
@crowsmathclass
2 ай бұрын
Thank you.
the explanation is so clear, thank you so much!!
@crowsmathclass
3 жыл бұрын
You’re welcome.
This was brilliant. Thank you.
@crowsmathclass
3 жыл бұрын
Thank you. Glad it helped.
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
3 жыл бұрын
Thank you for the comment. Glad it helped.
Thank you. You made this clear and simple.
@crowsmathclass
2 жыл бұрын
Thank you. Glad it helped.
Thank you, this worked, and you explain it better than my textbook lol
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
Brilliant video. Made this so easy to understand helped me with my assignment. Thank you!!
@crowsmathclass
3 жыл бұрын
Thank you. Glad it helped.
Buddy, you literally dug me out of a hole! Thanks man 👍🏻
@crowsmathclass
2 жыл бұрын
You’re welcome. Glad it helped.
@devereux20
2 жыл бұрын
@@crowsmathclass 😄🙏🏻
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
3 жыл бұрын
You’re welcome. Glad it helped.
@MR95.1
3 жыл бұрын
@@crowsmathclass yes it was very useful.....
This is very helpful. Thank you for sharing it.
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
Thank you for the video. It helped me a lot.
@crowsmathclass
2 жыл бұрын
You’re welcome. Glad it helped.
thank you much, really appreciate this, save me from doing a lot of manual work...
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
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?
thank you so so so so so so much! you help me a lot !!!
@crowsmathclass
3 жыл бұрын
You’re welcome. Glad it helped.
Thank you so much. 😊 finally I got the answer 🥳
@crowsmathclass
3 жыл бұрын
You are welcome 😊
Thank you Steve Crow!
@crowsmathclass
3 жыл бұрын
You’re welcome.
My man ! Appreciate it boss.
@crowsmathclass
2 жыл бұрын
You’re welcome.
Best explanation available thank you
@crowsmathclass
4 жыл бұрын
Thank you. Glad it helped.
It was too good. Wonderful & simple explanantion
@crowsmathclass
3 жыл бұрын
Thank you.
Finally, thanks for helping us
@crowsmathclass
3 жыл бұрын
You’re welcome.
Thank you for this video it helped alot
@crowsmathclass
3 жыл бұрын
You’re welcome.
Hey Buddy great video lots of help
@crowsmathclass
3 жыл бұрын
Thank you.
Extremely helpful.
@crowsmathclass
Жыл бұрын
Thank you. Glad it helped.
this was great, you so so much!
@diegoperezlopez6059
Жыл бұрын
thank you*
Unrelated topic but ur voice is really soothing 😌
@crowsmathclass
2 жыл бұрын
Thank you.
Thank you so much!
@crowsmathclass
2 жыл бұрын
You’re welcome.
Thank you... 😌😌😌for solving my problem
@O.rdinary_boy
2 жыл бұрын
How I can fix these random numbers???
@crowsmathclass
2 жыл бұрын
You’re welcome.
Well done. Nice explanation.
@crowsmathclass
Жыл бұрын
Thank you.
you are number 1 for me.
@crowsmathclass
2 жыл бұрын
Thank you.
Hi can you do a tutorial about making frequency table only colors?
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
2 жыл бұрын
It works for one column.
Great! Thank you
@crowsmathclass
Жыл бұрын
You’re welcome.
THANK YOU!!!
@crowsmathclass
Жыл бұрын
You’re welcome.
Thanks for helping
@crowsmathclass
3 жыл бұрын
You’re welcome.
you saved me from having to tally up 80 things 😭😭 thank you
@crowsmathclass
2 жыл бұрын
You’re welcome. Glad I could help.
Thank you so much
@crowsmathclass
2 жыл бұрын
You’re welcome.
U are hero man
@crowsmathclass
2 жыл бұрын
Thank you. Glad it helped.
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
2 жыл бұрын
You’re welcome. Glad it helped.
thanks!!
@crowsmathclass
3 жыл бұрын
You’re welcome.
wiiii, i made it. Hvala!
@crowsmathclass
Жыл бұрын
👍
Can you advise when you select the bin array, why would you exclude A11?
@crowsmathclass
3 жыл бұрын
You don’t include the highest interval.
@benjaminshen2079
3 жыл бұрын
@@crowsmathclass Thank you Steve
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
2 жыл бұрын
That is strange. Frequency function should be in your excel.
Thank you
@crowsmathclass
3 жыл бұрын
You’re welcome.
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
4 ай бұрын
He selected 4 cells And there are 3 cells for the bin array
How to sort this matrix in ascending order?
Ctrl+Shift+Return is the key
@aureliendv9374
3 жыл бұрын
What about new macs that don't have a return button anymore?
Can the data aray be just one column of Numbers?
@crowsmathclass
3 жыл бұрын
Yes.
@sulleymanissaka6729
3 жыл бұрын
Thanks, I tried it worked
enter or "Inner" ????
Are you sure you aren't Bob Ross?
👌
how did u get 0 to 9 10 to 19 ITS SO CONFUSING po huhu
@christianevensantillan2036
3 жыл бұрын
Ikaw yong magdedecide nong interval na gusto mo po
I don't get where you pulled your intervals from
@crowsmathclass
2 жыл бұрын
I just made them up.
@sarahcoleman9480
2 жыл бұрын
@@crowsmathclass what if I only have one column of numbers and some are decimals
@crowsmathclass
2 жыл бұрын
You have to have two columns.
@sarahcoleman9480
2 жыл бұрын
@@crowsmathclass nope I have one
@crowsmathclass
2 жыл бұрын
The frequency function tells you how many data values are between two numbers. This is why you must have two columns of numbers.