Choosing Class Intervals (Excel Bins)
HTML-код
- Опубликовано: 10 ноя 2016
- 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)
I finally found a good explanation of what I have been trying to do for the last 2 hours. THANK YOU,
This video just saved my life! I was crying over my stats homework and this helped so much lol
This has been so, so, so helpful for me. Thank you very much.
Thanks! Really great video! I have been trying to figure this out for hours and your video helped!
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
Thank you very much, Prof. Scott. Very helpful for measuring bubble size in research
Thanks so much. I like how you break things up.
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
Thank you so much. You clearly explained step by step the process.
thank you for posting this!
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
Brilliant 👏 Thank you so much 😊
Thank you so much. It is really helpful. :)
Thank you for your explanation. Now I understand. Cool.😃😃😃😃
very helpful! thanks!
This is good, man
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
thankyou for this video learned well
Very good, thank you.
Thank you for this video :)
Very helpful 💫
Thank you very much Sir
thanks man, I wish a had a million dollars to send you
You can add f4 to add dollar sign all at once.
Thank you 🙏
Very helpful
excellent tank u sir
thanks!
the amount of times i asked what the dollar sign do, I only understand after I watched this
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
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.
Thanku
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?"
dankii bafanas
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.
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.
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
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.)
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
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