Choosing Class Intervals (Excel Bins)
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-matic.com)
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-matic.com)
Пікірлер: 53
I finally found a good explanation of what I have been trying to do for the last 2 hours. THANK YOU,
This has been so, so, so helpful for me. Thank you very much.
Very helpful, have an IED test tomorrow and this came In handy to study for
Thank you so much for this. It was so helpful for my stats homework!
Thanks! Really great video! I have been trying to figure this out for hours and your video helped!
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
Thanks so much. I like how you break things up.
This video just saved my life! I was crying over my stats homework and this helped so much lol
Thank you very much, Prof. Scott. Very helpful for measuring bubble size in research
thank you for posting this!
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 so much. You clearly explained step by step the process.
Thanks so much!! :) This actually helped.
This definitely helped me in my home work Thanks :)
I LOVE YOU MAN !!
Thanks! It helps me a lot
Thank you so much. It is really helpful. :)
Brilliant 👏 Thank you so much 😊
This is good, man
very helpful! thanks!
Thank you for your explanation. Now I understand. Cool.😃😃😃😃
thankyou for this video learned well
Very good, thank you.
Thank you for this video :)
You can add f4 to add dollar sign all at once.
Very helpful 💫
Thank you very much Sir
Thank you 🙏
thanks man, I wish a had a million dollars to send you
Very helpful
excellent tank u sir
Hi Scott, I have a dataset with 16000+ entries. Can I use more than a hundred bins contrary to your suggestion in the video?
@ScottDellinger
2 жыл бұрын
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.
the amount of times i asked what the dollar sign do, I only understand after I watched this
thanks!
hello sir iam littelbit confused about how do you choose number of bin =7 pleas explain me
@ScottDellinger
5 жыл бұрын
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?"
how do u get to "data analysis" in 1:32?
@ScottDellinger
7 жыл бұрын
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
Prof. scott can you please explain how we decide bin number as here you take 7
@ScottDellinger
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.
how do i do bin size that goes 1-10 to 10-100 to 100-1000 then 1000-10000
@ScottDellinger
6 жыл бұрын
adsonkool Just use those numbers for your bin sizes and skip all my calculations that make them all the same size.
Thanku
dankii bafanas
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.
@ScottDellinger
3 жыл бұрын
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.)
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
Where is the data analysis button?
@ScottDellinger
2 жыл бұрын
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
thank you so much, it helped me a lot
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