Some students are confused on how to sort data into class intervals or "bins" in Excel. This video explains a method to easily choose bins. (Recorded with screencast-o-ma...)
it works, but may I mention that I can't see the tabs you are using. but following the names of the tabs you mentioned I managed to get the same result. thank you
I feel like there is an error somewhere in here. You used 0.018 as the range and divided by 6 bins to get 0.003 as the bin size. You then made 7 bins to include all the data. Also, typically when I see histograms, each column includes the upper and lower edges of each range.
No...as long as your bins are the same size and you make sure every datapoint fits into a bin everything is good. As to the column showing the bounds, you can certainly choose to format it that way of you so choose. This video originally was intended for 14-15 year old students, so I was focused more on getting them to visualize data. (This was early in their statistics lessons.)
Yes. I originally made this video for one of the classes I teach, so the advice was tailored specifically for them (14-15 years old). I didn't want them to get lost in the Freedman-Diaconis rule, and figured their statistics teacher in 4 years would cover. If I had known this would become my most popular video watched by adult learners, I would have done things a little differently.
There is no "best" number of bins, and different bin sizes can reveal different features of the data. Since this video was originally for 14 year old students, I just give some general "rules of thumb" that generally work well (the 1-4 items in the text box in the video) when picking bin number and width. This is where the "7" comes from, and work wells for simple data visualizations. Using wider bins in smaller datasets can reduce noise due to sampling randomness; using narrower bins in larger datasets can give you greater precision. At a higher level there are many approaches to calculating bin number and width. One of the most common for the number of bins is simply taking the square root of the number of data points and rounding up. If you want to read more I would suggest en.wikipedia.org/wiki/Histogram#Number_of_bins_and_width.
Seven bins is just what worked for this data. I look at the min and max values and then picked a logical offset (0.003" each) that would give me between 5-20 bins. For this a "rule" does not exist. Think, "If I use this size container does it show my data in a well organized way?"
First you have to load and Load and activate the Analysis ToolPak. 1) Click the FILE tab, click OPTIONS, and then click the ADD-INS category. ...2) In the Manage box, select Excel Add-ins and then click Go. ...3) In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. Finally In the tabs across the top click DATA -> DATA ANALYSIS (look to the far right) -> DESCRIPTIVE STATISTICS
Data tab -> Analysis -> Data Analysis. I don't THINK that it is enabled by default so you may have to load the plug-in yourself first. That's more complicated but this link to Microsoft support article will help. You want the "Load and activate the analysis ToolPak" section. support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6
you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude
you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude
you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude
it works, but may I mention that I can't see the tabs you are using. but following the names of the tabs you mentioned I managed to get the same result. thank you
I finally found a good explanation of what I have been trying to do for the last 2 hours. THANK YOU,
Thank you so much for this. It was so helpful for my stats homework!
Very helpful, have an IED test tomorrow and this came In handy to study for
This video just saved my life! I was crying over my stats homework and this helped so much lol
This video was exactly what I needed. Thank you Scott!
This has been so, so, so helpful for me. Thank you very much.
This definitely helped me in my home work
Thanks :)
Thank you so much. You clearly explained step by step the process.
Thanks! Really great video! I have been trying to figure this out for hours and your video helped!
Hi, do you know how to specify the bin as a range, e.g. 0.74 - 0.743, 0.743- 0.746, etc., instead of a number? Thank you
Thank you very much, Prof. Scott. Very helpful for measuring bubble size in research
Thank you for your explanation. Now I understand. Cool.😃😃😃😃
thankyou for this video learned well
I feel like there is an error somewhere in here. You used 0.018 as the range and divided by 6 bins to get 0.003 as the bin size. You then made 7 bins to include all the data. Also, typically when I see histograms, each column includes the upper and lower edges of each range.
No...as long as your bins are the same size and you make sure every datapoint fits into a bin everything is good. As to the column showing the bounds, you can certainly choose to format it that way of you so choose. This video originally was intended for 14-15 year old students, so I was focused more on getting them to visualize data. (This was early in their statistics lessons.)
Thanks so much. I like how you break things up.
Brilliant 👏 Thank you so much 😊
Thanks! It helps me a lot
Very helpful 💫
thank you so much, it helped me a lot
Thanks so much!! :) This actually helped.
thank you for posting this!
Thank you 🙏
Thank you so much. It is really helpful. :)
very helpful! thanks!
Hi Scott, I have a dataset with 16000+ entries. Can I use more than a hundred bins contrary to your suggestion in the video?
Yes. I originally made this video for one of the classes I teach, so the advice was tailored specifically for them (14-15 years old). I didn't want them to get lost in the Freedman-Diaconis rule, and figured their statistics teacher in 4 years would cover. If I had known this would become my most popular video watched by adult learners, I would have done things a little differently.
excellent tank u sir
Prof. scott can you please explain how we decide bin number as here you take 7
There is no "best" number of bins, and different bin sizes can reveal different features of the data. Since this video was originally for 14 year old students, I just give some general "rules of thumb" that generally work well (the 1-4 items in the text box in the video) when picking bin number and width. This is where the "7" comes from, and work wells for simple data visualizations.
Using wider bins in smaller datasets can reduce noise due to sampling randomness; using narrower bins in larger datasets can give you greater precision. At a higher level there are many approaches to calculating bin number and width. One of the most common for the number of bins is simply taking the square root of the number of data points and rounding up. If you want to read more I would suggest en.wikipedia.org/wiki/Histogram#Number_of_bins_and_width.
hello sir iam littelbit confused about how do you choose number of bin =7 pleas explain me
Seven bins is just what worked for this data. I look at the min and max values and then picked a logical offset (0.003" each) that would give me between 5-20 bins. For this a "rule" does not exist. Think, "If I use this size container does it show my data in a well organized way?"
I LOVE YOU MAN !!
thanks man, I wish a had a million dollars to send you
how do u get to "data analysis" in 1:32?
First you have to load and Load and activate the Analysis ToolPak. 1) Click the FILE tab, click OPTIONS, and then click the ADD-INS category. ...2) In the Manage box, select Excel Add-ins and then click Go. ...3) In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.
Finally In the tabs across the top click DATA -> DATA ANALYSIS (look to the far right) -> DESCRIPTIVE STATISTICS
You can add f4 to add dollar sign all at once.
This is good, man
Thank you very much Sir
Thank you for this video :)
Very helpful
Very good, thank you.
the amount of times i asked what the dollar sign do, I only understand after I watched this
thanks!
Thanku
dankii bafanas
Where is the data analysis button?
Data tab -> Analysis -> Data Analysis. I don't THINK that it is enabled by default so you may have to load the plug-in yourself first. That's more complicated but this link to Microsoft support article will help. You want the "Load and activate the analysis ToolPak" section. support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6
you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude
how do i do bin size that goes 1-10 to 10-100 to 100-1000 then 1000-10000
adsonkool Just use those numbers for your bin sizes and skip all my calculations that make them all the same size.
you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude
you’re a blessing 👆👆👆to me no one has every continuously helped me like you have I thank God for ur presence in my life you’re the best !!! Thanks dude